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.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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).
 
Upvote 0
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
 
Upvote 0
Data tables in charts are very limited and I don't think that is possible. You would need to change the series order.
 
Upvote 0

Forum statistics

Threads
1,214,965
Messages
6,122,496
Members
449,089
Latest member
Raviguru

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
Back
Top