Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i want to display the month from a date into another cell | Excel Worksheet Functions | |||
how do i display the total number of days in the current month in. | Excel Discussion (Misc queries) | |||
How do I format the date in a footer to display the month in lett. | Excel Discussion (Misc queries) | |||
Axis display as category | Charts and Charting in Excel | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |