ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Comparing 2 graphs (https://www.excelbanter.com/charts-charting-excel/121131-comparing-2-graphs.html)

Jamie

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

Jon Peltier

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





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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com