Data table in chart?

  • Thread starter Thread starter Michael Raphael
  • Start date Start date
M

Michael Raphael

I have some line chart portraying responses to 20 items.

I would like to put a table under each chart the shows the value of not only the responses that are charted but also the percentage difference between the two.

My problem and the question is that if I use the 'data table' option in creating the chart the row with the difference is not there. Then if I try to paste a table under the chart it does not line up with the columns of the line chart.

Any ideas of how to put a table with 3 lines of data under a line chart of 2 lines?

Thanks,

Mike
 
There is a response in the Excel.Misc. group
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


"Michael Raphael"
<[email protected]>
I have some line chart portraying responses to 20 items.
I would like to put a table under each chart the shows the value of not only the responses that are charted but also the percentage
difference between the two.

My problem and the question is that if I use the 'data table' option in creating the chart the row with the difference is not there.
Then if I try to paste a table under the chart it does not line up with the columns of the line chart.
Any ideas of how to put a table with 3 lines of data under a line chart of 2 lines?
Thanks,
Mike
 
Plot all three series in your chart, and make the one that you don't want to
show (the % diff) invisible by choosing the dots/line colour similar to the
plot area background colour.
 
Cool idea. Didn't think of it being that easy!!!!!!!
Guess I should think of that first before trying all the 'fancy' stuff.

Thanks,

Plot all three series in your chart, and make the one that you don't want to
show (the % diff) invisible by choosing the dots/line colour similar to the
plot area background colour.
 
Back
Top