If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Secondary Axis | Ann | Charts and Charting | 5 | October 21st, 2005 09:38 AM |
Secondary Axis chart | McInnes | Charts and Charting | 1 | September 16th, 2005 08:17 PM |
Different Secondary X Axis but same Y Axis | Mutiny_92 | Charts and Charting | 1 | August 16th, 2005 05:17 PM |
Secondary Axis | iris | Charts and Charting | 3 | August 4th, 2005 04:27 PM |
data to chart on primary axis | jw | Charts and Charting | 6 | September 24th, 2003 12:46 AM |