Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy charting question (hopefully) | Charts and Charting in Excel | |||
Charting Textual Statistics | Charts and Charting in Excel | |||
XL Chart: Separately align series and value data labels | Charts and Charting in Excel | |||
Can tick mark labels be flipped about axis? | Charts and Charting in Excel | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |