Formatting Numbers Help

  • Thread starter Thread starter zioneye
  • Start date Start date
Z

zioneye

I'm working with some bar charts that display a wide range of values.
Problem is that they chart large sums and much smaller sums. The large
sums are obvious when displayed but the smaller sums are barely
viewable. Is there a way to balance this out so that the bars are in
perspective? I need to compare data where some values may be in the
millions and others in the hundreds.

Z
 
The usual way is to pick a chart type that gives you two vertical axes -
could be a line chart or combination chart. Then the smaller ranges can
be charted on another axis.

Regards
Mike
 
You must log in or register to reply here.

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

status bar sum function 5
How to get the sum of B:C by counting the instances that a nameappears in range A 8
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Conditional formatting for values in a column that exceed a set limitwhen summed 4
Sum number range ignoring numbers formatted as text 0
Group dates onto a chart 3
Help on an IF formula 3
Minus Zero 11

Back
Top