Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to decrease tick mark labels in Area/Line combo chart?
I have an area/scatter line combo chart. I'm plotting weeks for two years on the X axis. It's actually consists of 2 columns of data. Column B will have the weeks as 1,2,3, and 4 then the same number again 1,2,3,4. While col A will show the period (every 4 weeks = one period) for a total of 13 period for the first year and the same for the second year. Plotting 104 weeks on the X axis makes it hard to see/read. I couldn't adjust the 'number of categories between tick mark lables', I guess because the chart contains area type. I have tried to add a dummy scatter line, so I can adjust the labels from showing each and everyone to may be show one every 3 weeks, but the option still grayed out. Any idea on how to make this legible? Thanks. -- when u change the way u look @ things, the things u look at change. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change tick mark labels in z axis from values to texts? | Charts and Charting in Excel | |||
Tick Mark Label Line Wrap | Charts and Charting in Excel | |||
How do I justify/align tick mark labels on a horizontal bar chart? | Charts and Charting in Excel | |||
Can tick mark labels be flipped about axis? | Charts and Charting in Excel | |||
tick mark labels | Charts and Charting in Excel |