ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do I create a line graph for part of the periods? (https://www.excelbanter.com/charts-charting-excel/39005-how-do-i-create-line-graph-part-periods.html)

Harold Rostoker

how do I create a line graph for part of the periods?
 
I want to put two line graphs on one chart but each line is for a subset of
the periods.

Jon Peltier

Harold -

Set up the data like this:

Srs A Srs B
a 1
b 2
c 3
d 4 4
e 5
f 6
g 7

and Series A will cover a-d and Series B will cover d-g.

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


Harold Rostoker wrote:

I want to put two line graphs on one chart but each line is for a subset of
the periods.



All times are GMT +1. The time now is 03:58 PM.

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