A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Chart datatables



 
 
Thread Tools Display Modes
  #1  
Old September 29th, 2003, 12:21 PM
Don Niall
external usenet poster
 
Posts: n/a
Default 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  
Old September 29th, 2003, 09:14 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:02 PM.


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