#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 191
Default Comparing 2 graphs

Is it possible to automatically set a 'difference' line between two series
values in a graph/chart.

For Example:

In January Peter sells 50 units and Gareth sells 20 units. How could I get a
line to appear between each node/series point to show the difference of 30?

--
Jamie
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Comparing 2 graphs

In a line chart, you could use High-Low lines or Up-Down bars. I discuss
these features on this web page:

http://peltiertech.com/Excel/ChartsH...artTricks.html

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


"Jamie" wrote in message
...
Is it possible to automatically set a 'difference' line between two series
values in a graph/chart.

For Example:

In January Peter sells 50 units and Gareth sells 20 units. How could I get
a
line to appear between each node/series point to show the difference of
30?

--
Jamie



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing Line graphs Clueless Charts and Charting in Excel 2 October 15th 06 09:53 PM
Pasting Graphs - making me crazy! BankC Excel Discussion (Misc queries) 1 April 25th 06 06:12 PM
HYPERLINK GRAPHS Aurora Charts and Charting in Excel 0 April 10th 06 04:46 PM
Are there better GRAPHS within EXCEL or Add-on graphs? Deb Charts and Charting in Excel 1 February 1st 06 01:19 PM
Charts and Line Graphs comparing companies with different data Joyous412 Charts and Charting in Excel 1 January 31st 06 02:44 AM


All times are GMT +1. The time now is 04:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"