How do I plot values to match log scale on chart? Ron Hudson

R

Ron Hudson

Some of the lower values, the start and stop of the bars, are ok. Some
higher values which appear in higher decades do not match the chart values.
What is wrong and how should I fix it?
Ron Hudson
 
S

Shane Devenshire

Hi,

Possible answer - on a log scale the increments are not equal distance
apart. Therefore a value of 75 is not halfway between 50 and 100. This is
the correct.

Cheers,
Shane Devenshire
 
D

David Biddulph

Are you perhaps using a 3-D effect? If so, you can get a misleading
impression of the height of a column.
 
M

MartinW

Hi Ron,

In some situations you can present your data better by converting
it to log values first and then plot it on a natural scale as opposed to the
normal way of plotting natural values on a log scale.

Just some food for thought
Martin
 
J

Jon Peltier

In stacked bars, each bar reaches to the sum of it and all previous bars. If
the two items in the stack are 2 and 3, the first bar goes to 2, the second
goes to 3 more than that, or 5.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I partially fill a plot area with color? 4
Calculate the median value before a specified list 0
Macro to change position of chart labels on line chart 1
Log scale and minor gridline labels 2
Employee Schedule not plotting properly - chart type / data series not correct 0
Problem with Excel 2007 clustered column chart on log scale 1
Invert bar chart content but not the axes 1
Values plotted outside of Axis scale 6

Top