Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Autoscaling on XY chart
Hi,
Is VBA the only solution to autoscale axis in an XY plot...? I would like to set the min and max for my x-axis as my data changes. (I know how to do it through VBA). Or is there any other short-cut? -- - Mangesh ------------------------------------------ Office 2003 & Windows XP |
#2
|
|||
|
|||
Hi,
Unfortunately you can not link the min/max of the scale to cells directly. I think VBA is the only approach to dynamic updating of those properties. Cheers Andy Mangesh Yadav wrote: Hi, Is VBA the only solution to autoscale axis in an XY plot...? I would like to set the min and max for my x-axis as my data changes. (I know how to do it through VBA). Or is there any other short-cut? -- - Mangesh ------------------------------------------ Office 2003 & Windows XP -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Yes, thats true. But I remember vaguely that Tushar Mehta had suggested some
method quite some days back. I may be wrong, it could be for some other chart type (and not XY). Mangesh "Andy Pope" wrote in message ... Hi, Unfortunately you can not link the min/max of the scale to cells directly. I think VBA is the only approach to dynamic updating of those properties. Cheers Andy Mangesh Yadav wrote: Hi, Is VBA the only solution to autoscale axis in an XY plot...? I would like to set the min and max for my x-axis as my data changes. (I know how to do it through VBA). Or is there any other short-cut? -- - Mangesh ------------------------------------------ Office 2003 & Windows XP -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
Hi Tushar,
Thanks for the response. I have already checked the addin on your link, and I don't want to go that way. I think what I was refering to was probably some other chart type. Anyway, if I ever find it tou, will let you know. Mangesh "Tushar Mehta" wrote in message om... The only option that comes to mind is an add-in that works 'behind the scenes.' See AutoChart Manager http://www.tushar-mehta.com/excel/so...art/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Yes, thats true. But I remember vaguely that Tushar Mehta had suggested some method quite some days back. I may be wrong, it could be for some other chart type (and not XY). Mangesh "Andy Pope" wrote in message ... Hi, Unfortunately you can not link the min/max of the scale to cells directly. I think VBA is the only approach to dynamic updating of those properties. Cheers Andy Mangesh Yadav wrote: Hi, Is VBA the only solution to autoscale axis in an XY plot...? I would like to set the min and max for my x-axis as my data changes. (I know how to do it through VBA). Or is there any other short-cut? -- - Mangesh ------------------------------------------ Office 2003 & Windows XP -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
|
|||
|
|||
On Wed, 10 Aug 2005 17:10:05 +0530, "Mangesh Yadav"
wrote: Hi Tushar, Thanks for the response. I have already checked the addin on your link, and I don't want to go that way. I think what I was refering to was probably some other chart type. Anyway, if I ever find it tou, will let you know. Mangesh The only other way I can think of is to create a "fake" data set that only contains the data that fall within your boundaries and then let the chart auto-scale options sort it out. i.e. if you want the "x-axis" to be from 5 to 10 then you'd filter out any data points where the x value was outside this range. |
#7
|
|||
|
|||
Hi Paolo,
Thanks for the response. Anyway, at the moment I am going ahead with the VBA solution. Mangesh "Paolo" wrote in message ... On Wed, 10 Aug 2005 17:10:05 +0530, "Mangesh Yadav" wrote: Hi Tushar, Thanks for the response. I have already checked the addin on your link, and I don't want to go that way. I think what I was refering to was probably some other chart type. Anyway, if I ever find it tou, will let you know. Mangesh The only other way I can think of is to create a "fake" data set that only contains the data that fall within your boundaries and then let the chart auto-scale options sort it out. i.e. if you want the "x-axis" to be from 5 to 10 then you'd filter out any data points where the x value was outside this range. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel |