How to display data WITH a Chart but not IN the Chart?

[alank]

Is there a way to include or display data WITH a chart and yet not have the data displayed IN the chart?

For example, imagine a bar graph, with each bar divided into two portions, red and green. The data table will include the counts for red and green for each bar (let's say one bar per person or group). Now, say I want to include an additional two rows of data, maybe a percentage change or absolute change for the counts of green and red from last month to this month. These additional two rows provide information and context, but should not be reflected in the chart itself. So far, however, I have been unable to produce this result, and these third and fourth rows get included in the bars (with new colors). Is there a way to exclude these data from the chart and yet display the data in the table accompanying the chart?

Any solutions?

Thank you, and be well!

Alan K

krinskya@ummhc.org

 

[pplstuff]

Can you just add a text box over each bar with the data?

Alternatively, if you want it dynamic, change the series name to the data you want shown and then use data labels->show series name.

 

[tusharm]

1) Share your email address only if you want unwanted emails.

2) Simulate the effect. See Custom Chart Table
Custom Chart Table

Is there a way to include or display data WITH a chart and yet not have the data displayed IN the chart?

For example, imagine a bar graph, with each bar divided into two portions, red and green. The data table will include the counts for red and green for each bar (let's say one bar per person or group). Now, say I want to include an additional two rows of data, maybe a percentage change or absolute change for the counts of green and red from last month to this month. These additional two rows provide information and context, but should not be reflected in the chart itself. So far, however, I have been unable to produce this result, and these third and fourth rows get included in the bars (with new colors). Is there a way to exclude these data from the chart and yet display the data in the table accompanying the chart?

Any solutions?

Thank you, and be well!

Alan K

krinskya@ummhc.org