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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

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,127,245
Messages
5,623,586
Members
415,981
Latest member
Baltwin

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