chart

[ladym]

Operating System: Mac OS X 10.5 (Leopard)

I'm trying to make a bar graph that plots values that are extremely small. They won't show up on the chart even when I change the scale on the y-axis. What should I do?

 

[Shane Devenshire]

Hi,

What version of Excel are you using? Show us some sample data. When you
say "they" won't show, what is "they"?

 

[CyberTaz]

The size of the values shouldn't make any difference - it's the *range*
spanned by the values that determines the relative length of the bars.

If the range of values is extreme [such as .015 - 2,000] the bars
representing the lower values will be hard to see. If that's the case Bar or
Column charts may not be the appropriate type of chart. Perhaps you'd do
better to use a Line chart or something that more effectively plots the
range of values involved. Without more details, however, it's impossible to
offer any specific suggestions. If you need more assistance please include
your Office version info as well as a more detailed description.

Regards |:>)
Bob Jones
[MVP] Office:Mac