Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael Raphael
 
Posts: n/a
Default Charting labels question

I asked this in the Charting newsgroup also.

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone
 
Posts: n/a
Default Charting labels question

Mike,
Include the row with the differences in the source data for the chart.
Format the differences series so it is invisible.
Add your data table.

Should work, but I haven't tested it.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Michael Raphael"
wrote in message
I asked this in the Charting newsgroup also.
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Easy charting question (hopefully) [email protected] Charts and Charting in Excel 3 May 11th 06 12:08 PM
Charting Textual Statistics TheDevil Charts and Charting in Excel 5 April 24th 06 12:45 AM
XL Chart: Separately align series and value data labels Stuart Bratesman Charts and Charting in Excel 3 August 10th 05 11:07 PM
Can tick mark labels be flipped about axis? [email protected] Charts and Charting in Excel 1 July 20th 05 05:03 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM


All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"