scale of sales and net income chart

P

PBJ

I'm using Excel 2007 and need to chart the following:
Sales 10,000
Operating Income 1,000
Net Income 500

Excel is creating the chart from these numbers, but because Sales are so
high compared to Op Income and Net Income, I can barely see the 2 smaller
numbers on the chart.

I'm already using a secondary axis for a statistical calculation, or it
would be the perfect solution.

I've experimented with scale (in Excel 2003) but haven't gotten too far.

Any help for this? TIA.
 
S

Shane Devenshire

Hi,

Here are two ideas:
1. Create a dummy axis for one of the sets of data, check Jon's web site for
topics related to this subject.
2. Use a Log scale - the down side of this is not everybody is comfortable
viewing this chart type.
 

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

inaccurate line chart 3
Chart Axis 7
How do I set the scale of one pie chart to another chart 1
Two series, two scales on single axis ? 3
user defined scale on chart 3
can i do this type of stacking column chart? (and how?) 3
Column chart not displaying some data points - Excel 2003 3
Data showing incorrectly on line chart 1

Top