Display every 3rd category name but still display latest month
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 |
Display every 3rd category name but still display latest month
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 |
All times are GMT +1. The time now is 07:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com