| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using a variable for a chart limit
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible, but there is a lot of experience out there. Thanks in advance. -- Vince F |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Using a variable for a chart limit
Hi,
See Jon's information http://peltiertech.com/Excel/Charts/...nkToSheet.html Cheers Andy Vince F wrote: Since I got instant help on my last query, is there any way to use a cell reference as an axis minimum or maximum in format axis? It seems impossible, but there is a lot of experience out there. Thanks in advance. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Using a variable for a chart limit
Andy
Thanks. I have handed this off to our local VBA expert and he says this should do it. Take care. -- Vince F "Andy Pope" wrote: Hi, See Jon's information http://peltiertech.com/Excel/Charts/...nkToSheet.html Cheers Andy Vince F wrote: Since I got instant help on my last query, is there any way to use a cell reference as an axis minimum or maximum in format axis? It seems impossible, but there is a lot of experience out there. Thanks in advance. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Using a variable for a chart's primary and secondary limits
How would you do this with a secondary axis? My issue is I have 2 Y axes and
I want them both to adjust relative to each other based on the data. I know I can manually change the maximum values, but I would rather change the value in which the 2 axes relate and have the charts adjust accordingly. For example, 6 on the primary axis will equal 1 on the secondary, 12 will be 2, and so on. If I need to adjust it to, say 5 and 1, how could I accomplish that without manual chart adjustments? Phillip "Andy Pope" wrote: Hi, See Jon's information http://peltiertech.com/Excel/Charts/...nkToSheet.html Cheers Andy Vince F wrote: Since I got instant help on my last query, is there any way to use a cell reference as an axis minimum or maximum in format axis? It seems impossible, but there is a lot of experience out there. Thanks in advance. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Using a variable for a chart's primary and secondary limits
Hi,
The same way only you need to reference the secondary axis. With ActiveChart.Axes(xlValue, xlSecondary) .MaximumScale = 6 ' Constant value .MinimumScale = dYmin ' VBA variable .MajorUnit = ActiveSheet.Range("A1").Value ' Worksheet range value End With Cheers Andy Read mo http://peltiertech.com/Excel/Charts/...#ixzz0nbeBaxVT On 11/05/2010 03:07, PYO1012 wrote: How would you do this with a secondary axis? My issue is I have 2 Y axes and I want them both to adjust relative to each other based on the data. I know I can manually change the maximum values, but I would rather change the value in which the 2 axes relate and have the charts adjust accordingly. For example, 6 on the primary axis will equal 1 on the secondary, 12 will be 2, and so on. If I need to adjust it to, say 5 and 1, how could I accomplish that without manual chart adjustments? Phillip "Andy Pope" wrote: Hi, See Jon's information http://peltiertech.com/Excel/Charts/...nkToSheet.html Cheers Andy Vince F wrote: Since I got instant help on my last query, is there any way to use a cell reference as an axis minimum or maximum in format axis? It seems impossible, but there is a lot of experience out there. Thanks in advance. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Using a variable for a chart's primary and secondary limits
One (non-VBA) approach is to plot a dummy series with appropriate values
on each axis and then make this invisible (no lines, no markers), then set both axes back to automatic. So for axis 1, plot the MAX value (or maybe use CEILING(MAX(your_range),2) to round up to the next 2 or 5 or some other 'round' number). For axis 2 plot a dummy series which is 1/6 of the one you worked out for axis 1. Hope this helps. Adam On 11/05/2010 03:07, PYO1012 wrote: How would you do this with a secondary axis? My issue is I have 2 Y axes and I want them both to adjust relative to each other based on the data. I know I can manually change the maximum values, but I would rather change the value in which the 2 axes relate and have the charts adjust accordingly. For example, 6 on the primary axis will equal 1 on the secondary, 12 will be 2, and so on. If I need to adjust it to, say 5 and 1, how could I accomplish that without manual chart adjustments? Phillip "Andy Pope" wrote: Hi, See Jon's information http://peltiertech.com/Excel/Charts/...nkToSheet.html Cheers Andy Vince F wrote: Since I got instant help on my last query, is there any way to use a cell reference as an axis minimum or maximum in format axis? It seems impossible, but there is a lot of experience out there. Thanks in advance. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Best way to limit data for chart? | Charts and Charting in Excel | |||
| Control Limit and 3-D chart | Charts and Charting in Excel | |||
| how can I limit my chart | Charts and Charting in Excel | |||
| Chart limit? | Charts and Charting in Excel | |||
| How do I add a limit line to a chart, so I can see where a data p. | Charts and Charting in Excel | |||
Linear Mode
