Chart datatables

  • Thread starter Thread starter Don Niall
  • Start date Start date
D

Don Niall

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-
 
[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
 
Back
Top