Chart with Data Table

aabbasi

Board Regular
Joined
Mar 4, 2002
Messages
188
Hi

I hope someone can solve my problem.

I have a "Chart with Data Table". I like to show 3 series of values on "Chart" and the 4th series I just like to show as "Data Table" which is underneath the chart. Is this possible? In other words the chart will show only 3 series but the table will show 4 series of data. Thank you.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
I think that the only way to do this is to plot all 4 series but make the 4th series invisible (i.e. set points to none and lines to none).
 

aabbasi

Board Regular
Joined
Mar 4, 2002
Messages
188
Thank You VoG for a nice solution. One more question. If on the table I like top change the order of series how should I do it. I mean if I like to move series 4 to 2nd position where series 2 is, how should I do it. Thank You
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Data tables in charts are very limited and I don't think that is possible. You would need to change the series order.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,535
Messages
5,596,738
Members
414,094
Latest member
dingo_baby

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