Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel charts
I am trying to format the individual labels on the category axis on an Excel
chart. I want every other label in a different color and bold. But the entire category axis is formatted. Does anyone have a suggestion? The category axis is years - 1990 through 2005. I want the odd years to be bold and a different color than the even years. |
#2
|
|||
|
|||
When Excel doesn't let me do what I want with a chart axis, I draw my own:
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html Use this technique to make two different axes, one for even and one for odd, and hide the default axis Excel draws. With this technique and your data, you can just use the X values for the data labels, no special add-in required to use custom labels. Your data is like: 2001 0 2003 0 2005 0 if 0 is the minimum Y value. Although you can format data labels individually, I suggested two different series, so you can format the entire set of odd labels in one go, same for the evens. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ gethein wrote: I am trying to format the individual labels on the category axis on an Excel chart. I want every other label in a different color and bold. But the entire category axis is formatted. Does anyone have a suggestion? The category axis is years - 1990 through 2005. I want the odd years to be bold and a different color than the even years. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a freeware application for creating gant charts in excel | Charts and Charting in Excel | |||
Excel should be able to do log to base 2 charts | Charts and Charting in Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Copy multiple charts from Excel to Power Point | Charts and Charting in Excel | |||
Why will my Excel charts not print in color? | Charts and Charting in Excel |