Removing 1 Item from the Data Table Below a Chart

[glennchung]

Hi

I tried searching and I can't anything related to this topic. Hope you can help.

In a line graph, I have three series--one is the goal, one is 2012 data, and one is 2011 data in grey.

I have added data labels to the 2012 line so that's taken care of. I only want to include 2011 data in the data table below the chart. How can I do that? If I add the data table, I have all three series and I can't remove any one of them manually.

Thank you!!

Using Excel 2010 and Windows XP

[teylyn]

Hello,

you'll have to fake it.

Create a copy of the data set below the chart (the chart must be in a worksheet, not on a chart sheet)

Arrange the data set below the chart like you want to show it. Resize the chart area to include the cells below it, set the chart background to no fill and resize the plot area so it does not overlap the cells.

If you need help with this, post a sample file.

cheers,

[glennchung]

Thanks teylyn

I copied and paste as image of the data set and then added the grey line to the left.

Thanks!

2-14-2012 4-22-45 PM.png

[teylyn]

Looking good.

Please remember to mark the thread as solved.

-----
If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[glennchung]

Done, thanks!