Excel – Create a excel chart only with axis

chartsmicrosoft excelmicrosoft-excel-2010

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.

Related Question