Excel 2007 chart frustration

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Hi,
First time post, so be nice to me!

I'm having a problem with Excel 2007 in that I cannot get it to format a
chart the way I would like it. I'm sure the issue is a simple one for
those in the know!

This is what the chart looks like in Excel:
http://img202.imageshack.us/i/excelaxispuzzle.jpg/

This is what I'd like it to look like:
http://img689.imageshack.us/i/excelaxisgood.jpg/

The second (good) shot is done in Star Office Calc. My Uni have provided
me with Star Office, but I'd like to use Excel as I've paid for it!

Thanks

Simon
 
EXCEL 2007

Hi Simon, you appear to have a Column / Clustered Column Chart.

If you go to my website:-

http://www.pierrefondes.com/

- and look at item number 58 you will find something similar in the Chart
Worksheet.

All you need to do to create one is to highlight the cells you wish to
include in the chart then Insert / Charts group / select the chart that you
want (Column / Clustered Column) / OK.

Your chart will now launch.

You can also get more info by hitting the F1 Help Facility in EXCEL / there
is a section called Charts when the F1 screen first launches / click on that
/ then Chart types / then Present your data in a column chart.

If my comments have helped please hit Yes.

Thanks.
 
Format the scale of the vertical (value) axis so that the category axis
crosses at 0.001, not 1. Excel tries to cross at zero, and on a log
scale, log(1) is zero.

So right click on the vertical axis, choose Format from the pop up menu,
and on the main tab enter 0.001 for the Axis Crosses At value. in fact,
to make sure changing data does not force you to repeat this, choose a
very small value, like 0.0000000001. As long as the minimum of the axis
is greater than or equal to the value you enter, the X axis will cross
at the minimum of the Y axis.

It may be confusing to use a logarithmic scale in a bar chart. People
judge values by the length of the bars, which is why the Y axis of a bar
chart should always include zero. Since the lengths of bars on a log
scale are not proportional to the value but to the log of a value, you
should use a line or XY chart. People are more flexible when judging
values by the position of a marker along an axis.

- Jon
 
Back
Top