Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
secondary axis on chart | Excel Discussion (Misc queries) | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |