# Chart with Data Table

#### aabbasi

##### Board Regular
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

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
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
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
Data tables in charts are very limited and I don't think that is possible. You would need to change the series order.

#### aabbasi

##### Board Regular
Thank you very much !

Have a nice day.

Replies
1
Views
218
Replies
0
Views
87
Replies
0
Views
73
Replies
0
Views
122
Replies
3
Views
135

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.

### Which adblocker are you using?

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

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