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)
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)