Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto x range start value, xy charts
I have several Excel xy charts plotting data that updates
automatically. The x range varies from 0 to 40, 40 to 80, ... up to 560 to 600. I want the chart x values to start at the lowest x value in the data, but it actually starts at 0 for all values up to 160, then does what I want for higher x starting values. I have the x axis auto button selected. Can anyone tell me how to stop the minimum value defaulting to zero? Excel 2003 and Windows XP. |
#3
|
|||
|
|||
see if this idea helps
Sub setmin() x = Application.Min(Range("d1:d12")) Sheets("sheet4").ChartObjects("Chart 3"). _ Chart.Axes(xlValue).MinimumScale = x End Sub you may want to change x= x=formulaarray."=MIN(IF(d1:d120,d1:d12))" -- Don Guillett SalesAid Software wrote in message oups.com... I have several Excel xy charts plotting data that updates automatically. The x range varies from 0 to 40, 40 to 80, ... up to 560 to 600. I want the chart x values to start at the lowest x value in the data, but it actually starts at 0 for all values up to 160, then does what I want for higher x starting values. I have the x axis auto button selected. Can anyone tell me how to stop the minimum value defaulting to zero? Excel 2003 and Windows XP. |
#4
|
|||
|
|||
better
x=SMALL(d1:d100,COUNTIF(d1:d100,0)+1) -- Don Guillett SalesAid Software "Don Guillett" wrote in message ... see if this idea helps Sub setmin() x = Application.Min(Range("d1:d12")) Sheets("sheet4").ChartObjects("Chart 3"). _ Chart.Axes(xlValue).MinimumScale = x End Sub you may want to change x= x=formulaarray."=MIN(IF(d1:d120,d1:d12))" -- Don Guillett SalesAid Software wrote in message oups.com... I have several Excel xy charts plotting data that updates automatically. The x range varies from 0 to 40, 40 to 80, ... up to 560 to 600. I want the chart x values to start at the lowest x value in the data, but it actually starts at 0 for all values up to 160, then does what I want for higher x starting values. I have the x axis auto button selected. Can anyone tell me how to stop the minimum value defaulting to zero? Excel 2003 and Windows XP. |
#5
|
|||
|
|||
Thanks Don & Andy
Thanks for that, the macro will do what I want. A little surprising that this functionality isn't built in though! Doug Jenkins |
#6
|
|||
|
|||
glad to help
-- Don Guillett SalesAid Software wrote in message oups.com... Thanks Don & Andy Thanks for that, the macro will do what I want. A little surprising that this functionality isn't built in though! Doug Jenkins |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting source data range with Charts | Charts and Charting in Excel | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
initial size of new charts | Charts and Charting in Excel | |||
Comparing charts dynamically | Charts and Charting in Excel | |||
pie charts - how to include "zero" fields on Legends | Charts and Charting in Excel |