EXCEL CHART HELP WITH MACRO

BRADX · May 8th, 2002, 09:12 PM

Hello
I'm trying to set an excel graph/chart template which I can use for different sets of data. What I need is help setting my graph to atomatically adjust to having differnt number of variables on the x axis. I want to use the same chart template each time. Ex. Data set one has 50 x-variables, than I want to do another graph (using the same template) with 35 variables and I want excel to atomatically adjust the graph to plot only 35 variables and not show 15 blank spots after that. So basically, I was wondering if someone knows how to set up a formula so excel each time reconizes how many variables there is and adjusts. If someone could help me it would greatly appreciated.
Thanks a lot (sorry if this is lengthy)

Ivan F Moala · May 9th, 2002, 04:18 AM

Quote:

On 2002-05-08 20:12, BRADX wrote:
Hello
I'm trying to set an excel graph/chart template which I can use for different sets of data. What I need is help setting my graph to atomatically adjust to having differnt number of variables on the x axis. I want to use the same chart template each time. Ex. Data set one has 50 x-variables, than I want to do another graph (using the same template) with 35 variables and I want excel to atomatically adjust the graph to plot only 35 variables and not show 15 blank spots after that. So basically, I was wondering if someone knows how to set up a formula so excel each time reconizes how many variables there is and adjusts. If someone could help me it would greatly appreciated.
Thanks a lot (sorry if this is lengthy)

Have a look here for Dynamic chart labeling

http://www.tushar-mehta.com/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 09:12 PM	#1
BRADX New Member Join Date: May 2002 Posts: 8	Hello I'm trying to set an excel graph/chart template which I can use for different sets of data. What I need is help setting my graph to atomatically adjust to having differnt number of variables on the x axis. I want to use the same chart template each time. Ex. Data set one has 50 x-variables, than I want to do another graph (using the same template) with 35 variables and I want excel to atomatically adjust the graph to plot only 35 variables and not show 15 blank spots after that. So basically, I was wondering if someone knows how to set up a formula so excel each time reconizes how many variables there is and adjusts. If someone could help me it would greatly appreciated. Thanks a lot (sorry if this is lengthy)