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

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

"maryj" wrote:

> 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