I want to create an excel chart with only the axes namely x axis and y axis with x axis values ranging from 1 to 100 and y axis values ranging from 1 to 100
Is this possible? If so how to do it?
Note: The method prescribed for doing this should not to refer to any data for doing this, I want to directly create the chart by using commands.
I am using Excel 2010
Best Answer
You could put in 100 bits of data, all set to 0, to make a "blank" chart with 100 data points. You'll have to adjust the y-axis range to show 0-100. Record doing this as a macro, and it will provide that starting point you're asking about.