| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
I can't get Axis labels as I want!
I have table like this:
2002 2003 2004 2005 2006 2007 Q1 100,00 100,00 100,00 98,95 102,79 Q2 100,00 100,00 99,65 99,01 Q3 100,00 100,00 98,84 99,01 Q4 100,00 100,00 98,23 99,00 The problem is that when I chart the table I get into X-axis label years 2002-2007 right after each other. Excel doesn't seem to understand that they are supposed to fit only every fourth value in the line. So what I want to x-axis label is either this: 2002 Q2 Q3 Q4 2003 Q2 Q3 ...etc OR 2002 2003 2004...etc What excel gives me now is: 2002 2003 2004 ... etc Anyone knows how to fix this ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| labels closer to axis | Charts and Charting in Excel | |||
| Excel2003: Axis labels are truncated | Charts and Charting in Excel | |||
| Can tick mark labels be flipped about axis? | Charts and Charting in Excel | |||
| Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel | |||
| Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
Threaded Mode
