LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default Newbie needs a little help on the value axis

Never created a chart from Excel before.

My chart is simple. I simply need to chart 10 columns. 1 for each year
going back.

Actually each year needs to show 2 columns side by side, 1 showing the count
of our total portfolio (avg 180,000), and the other showing our onboard staff
for the given year (avg 50). As you can see already, the problem I'm having
with the chart I created using the wizard, using column type, is that the
value axis goes clear up to 200,000 in 20,000 increments. So his column
shows nice and fine but the staff on board column is not even visible as it
doesn't approach anywhere close to 20,000. How do I edit those values so
that the first ones would be increments of 10 until 100, then boost it out in
20,000 increments?

Also, the category axis shows numbers 1 through 10 for the columns. How do
I change those numbers to read the year I want?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need PivotChart x axis to cross Y axis at minimum Y axis value Aaron Charts and Charting in Excel 1 August 17th 07 08:51 AM
Real Newbie newbie question Dave New Users to Excel 0 January 10th 07 07:55 PM
Newbie...need more space between entries on X axis SRS Charts and Charting in Excel 1 October 21st 05 05:28 PM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM
Newbie Questions - X Axis and Data Range Eli Charts and Charting in Excel 2 June 17th 05 01:54 AM


All times are GMT +1. The time now is 10:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"