Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
What commands? VBA? Automation? – Voitcus Aug 23 '13 at 12:33
I mean, if you tell me how to do this via GUI, I can record a macro and know the command. If u can give me the vba code, that would be fine too. I searched a lot over the web, couldnt find any resource for this. – kira Aug 23 '13 at 12:34
Moreover, I want to do this because, I want only the lines or bars to change when I select different data and not the whole chart itself. I have to write a code for that. – kira Aug 23 '13 at 12:36
I think there is no possibility to have a chart without reference to any data. Consider putting a single point outside your range. If you mark any two cells that are empty, this would be ok. – Voitcus Aug 23 '13 at 12:39
up vote 2 down vote accepted

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.

share|improve this answer
It's enough to put one point of data. The axes ranges can be adjusted in chart settings. – Voitcus Aug 23 '13 at 13:18
Good point. @Kira, right click on the axis on the chart, and choose axis options to change the scale (to 100). You'll have to do this for both axis. – Aaron Thomas Aug 23 '13 at 13:21
This point can be even empty, so it does not affect your worksheet. – Voitcus Aug 23 '13 at 13:22

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.