Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
primary & secondary axis
How do you space the primary and secondary axis equally. I've been fooling
around with "Format Data SeriesOptions", but I can't get them equally spaced and with the same size. Is there something I'm missing or is Excel 2000 just trying to intimidate me???? Connie |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
primary & secondary axis
What to you mean by 'equally spaced'
Same range (Max1=max2, Min1=Min2) ? Same interval between gridline? Tell us more -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Connie Martin" wrote in message ... How do you space the primary and secondary axis equally. I've been fooling around with "Format Data SeriesOptions", but I can't get them equally spaced and with the same size. Is there something I'm missing or is Excel 2000 just trying to intimidate me???? Connie |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
primary & secondary axis
Bernard,
I'm trying to do something similar. Let me explain. I would like the 100% point of the secondary axis match the maximum value on the secondary axis. Let me give you an example. I have a chart where the maximum plotted value for the primary axis is 9840. The chart automatically sets the maximum for the primary axis to 12000. I'd like the maximum for the secondary axis to be 12000/9840 = 1.22 ... I suspect I'll need to do this programmatically. I nave a named range of "TotalRequirements" and I need to get the maximum value from that and set an upper level for the primary and secondary axis based on that value. How do I do this without any involvement by the user? Thanks in advance, Barb Reinhardt "Bernard Liengme" wrote: What to you mean by 'equally spaced' Same range (Max1=max2, Min1=Min2) ? Same interval between gridline? Tell us more -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Connie Martin" wrote in message ... How do you space the primary and secondary axis equally. I've been fooling around with "Format Data SeriesOptions", but I can't get them equally spaced and with the same size. Is there something I'm missing or is Excel 2000 just trying to intimidate me???? Connie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Secondary Axis | Charts and Charting in Excel | |||
Different Secondary X Axis but same Y Axis | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel |