X axis Scale

[Hezzy]

I have a bar graph with dates for the X axis. I have 3 months, Jul 08, Aug
08 & Sep 09. The X axis displays all the 08 months up to Sep 09. How do I
stop the other 08 months from showing up. The bars on the graph are
separated, I want them all together.

 

[ShaneDevenshire]

Hi,

Here are a number of things to do depending on what you mean by separated
1. If there should be only one month per bar - select the chart and choose
Chart, Chart Options, Axes, Category
2. Double-click the series on the chart and choose Options, Gap width 0
3. If you are displaying all the dates through Sept 09, it means that the
range include those dates. You need to reduce the Source Range. - With the
series selected on the chart notice that the range for the labels and data
are highlight with blue and purple borders. Place your mouse over the bottom
right corner blue square and when the mouse changes to a two headed arrow
drag it up or left as is appropriate to decrease the selection size. Repeat
this with the purple highlight.

 

[Hezzy]

Is there a way to upload a file so you can see exactly what I'm talking
about, it's hard to describe in words.

 

[Hezzy]

Thank you so much Shane, I clicked on Category in the scale and wallah my
graph was all better.

 

[Hezzy]

Now I have the same problem with a line graph. There is no category under
scale to check. How to I fix a line graph?

 

[ShaneDevenshire]

Hi,

Sorry to take so long getting back, yes

Just send it to me
(e-mail address removed)

 

[ShaneDevenshire]

Hi,

Same options available for line charts.

 

[Hezzy]

I'm using Excel 2000 and the category option is not available.

 

[Andy Pope]

Hi,

The same 3 options are available for line charts in xl2000. In fact xl97
also has them.

Chart Options > Axis > Primary Axis > Category

Cheers
Andy