ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   secondary axis chart (https://www.excelbanter.com/charts-charting-excel/230416-secondary-axis-chart.html)

Gene

secondary axis chart
 
I have a line chart for which I have developed several point to point trend
lines which I would like to overlay on the original line chart. The points
are represented in four sets of series as follows:
Date1 Value1 Daten Valuen Datez
Valuez
Date2 Value2 Daten+1 Valuen+1 Datez+1
Valuez+1

Date3 Value3 etc. etc.
Date4 Value4

etc.

I tried to set each of the sets up as scatter charts specifying the primary
x axis. That is strictly hang time. I tried to set up each pair of points
as separate series(that amounts to thirty of forty separate series). I
achieved the overlay but if I change the data(not the limits but the data
itself) I again hang; I suppose because the calculations that modify the
trend dates change the limits on those series. I left spaces between the
trends points because I don't want them connected. Any suggestions?

GeneS


All times are GMT +1. The time now is 12:42 PM.

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