Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
Real Newbie newbie question | New Users to Excel | |||
Newbie...need more space between entries on X axis | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
Newbie Questions - X Axis and Data Range | Charts and Charting in Excel |