If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart datatables
Hi,
Is there a way of including particular data points in a chart data-table - but excluding them from the graph? I have a chart consisting of two unique line charts. I would like to add an additional piece of relevant infrmation to the chart data table, but dont want these datapoints to be represented in the actual chart. Any ideas Don- |
#2
|
|||
|
|||
Chart datatables
[This followup was posted to microsoft.public.excel.charting with an
email copy to Don Niall. Please use the newsgroup for further discussion.] One option is to plot the data you want and then set all attributes to none effectively making it transparent (double click the new series and from the Patterns tab set everything to 'None'). Alternatively, while it is some more work, why not create your own 'data table?' Duplicate your data in cells adjacent to the chart and use custom formats to get the desired effect. Or copy the data of interest, then use SHIFT+ Edit | Paste Picture Link. Position this object as desired relative to the chart. Now, you can also add any additional information you want. -- Trouble finding replies to your posts? Use a newsreader. See the tutorial 'Outlook Express and Newsgroups' on my web site Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi, Is there a way of including particular data points in a chart data-table - but excluding them from the graph? I have a chart consisting of two unique line charts. I would like to add an additional piece of relevant infrmation to the chart data table, but dont want these datapoints to be represented in the actual chart. Any ideas Don- |
Thread Tools | |
Display Modes | |
|
|