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

alank

New Member
Joined
Sep 5, 2012
Messages
1
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
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

pplstuff

Well-known Member
Joined
Mar 9, 2012
Messages
951
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.
 
Upvote 0

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
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
 
Upvote 0

Forum statistics

Threads
1,186,441
Messages
5,957,870
Members
438,329
Latest member
Aimon Rauf

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top