Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2007

Tip: Looking for answers? Try searching our database.

How do I add a horizontal data line to a column chart?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
soconfused - 06 Sep 2007 13:42 GMT
I have two columns of data which I have charted, now I would like to put the
differences between the two.

For instance, if I have 926-843= 83, I want to be able to put that number on
my chart to show the difference.

Thanks
Signature

DMM

Jon Peltier - 06 Sep 2007 14:07 GMT
http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

>I have two columns of data which I have charted, now I would like to put
>the
[quoted text clipped - 5 lines]
>
> Thanks
soconfused - 06 Sep 2007 15:34 GMT
Jon, I'm having a bit of trouble with this.

On my chart at the present time, I have dates on the left axis and text on
the bottom axis.  The info in the chart are projected dates and actual dates.
I've been asked to put the difference for each category  I don't necessarily
have to plot it, just have the numbers there.  Can you help me?
Signature

DMM

> http://peltiertech.com/Excel/Charts/AddLine.html
>
[quoted text clipped - 14 lines]
> >
> > Thanks
Jon Peltier - 06 Sep 2007 15:39 GMT
When you said data line, I was not thinking of a set of labels in a line,
but rather of a line showing a target.

Compute the difference in the worksheet, then use one of these utilities to
add these values to one of the series as data labels:

   Rob Bovey's Chart Labeler, http://appspro.com
   John Walkenbach's Chart Tools, http://j-walk.com

Or add an invisible line chart series (no line, no markers) to the chart,
using a dummy date to position the points where you want them, and hang the
labels on this series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

> Jon, I'm having a bit of trouble with this.
>
[quoted text clipped - 24 lines]
>> >
>> > Thanks
soconfused - 06 Sep 2007 16:26 GMT
Thanks so much, that worked great.  At some point I will be able to phrase my
questions properly.

Thanks.
Signature

DMM

> When you said data line, I was not thinking of a set of labels in a line,
> but rather of a line showing a target.
[quoted text clipped - 44 lines]
> >> >
> >> > Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.