I'm trying to insert additional data into the labels of a bar chart to show the net difference between the charted parameters.
I've figured out how to attach a 'cell' value to append to the labeled data but I want to move the layout as to list the difference data in way to be more 'obvious'
In the attached sheet I want to list out the 51 below the 220 & the 39 under the 226 etc as to group the difference numbers between the raw data.
I'm still a bit green around the edges on charting & I couldn't find a way to do the 'math' in the chart but perhaps there is way to let the chart do the math & populate this data.
Ultimately this end result chart will be used by numerous individuals as a template so will need to auto populate the chart data points based on data similar to what's listed being pasted into the sheet.
thank you
I've figured out how to attach a 'cell' value to append to the labeled data but I want to move the layout as to list the difference data in way to be more 'obvious'
In the attached sheet I want to list out the 51 below the 220 & the 39 under the 226 etc as to group the difference numbers between the raw data.
I'm still a bit green around the edges on charting & I couldn't find a way to do the 'math' in the chart but perhaps there is way to let the chart do the math & populate this data.
Ultimately this end result chart will be used by numerous individuals as a template so will need to auto populate the chart data points based on data similar to what's listed being pasted into the sheet.
thank you