Display every 3rd category name but still display latest month

[maryj]

I don't know if this is possible or not. I have a chart with many months of
data. To make the chart more readable, I have it set so that only the name of
every 3rd month displays on the x axis. As we add the next month's data, the
name of that month does not display because of that setting. The boss does
not want to drop off the first month of the data. Is there any way to have
every third month appear but still always have the last month display? This
is a chart that will be updated monthly and continue to grow.

Any suggestions?

maryj

 

[HEK]

Mary:
It is possible but it requires some hard work. You have to make a dummy
series. I suggest to look into the example Andy Pope provides on his
website:
http://www.andypope.info/charts/hiliteaxislabels.htm. This explains the
principle, although you need to adopt the approach to your own conditions.
You also may like to make a dynamic range name, so yr chart auto-updates with
every fresh month. Many posts here how to do that.
HTH,
Henk