ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to decrease tick mark labels in Area/Line combo chart? (https://www.excelbanter.com/charts-charting-excel/177489-how-decrease-tick-mark-labels-area-line-combo-chart.html)

sahafi

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.


All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com