I have made the attached pivot table column chart. I was wondering if anyone knew an easy way to have the x-axis labels' font color match the color of the column and the legend series. As you can see I have 3 series and each column color corresponds to the legend. I would like the labels on the x-axis at the bottom of the chart to match those colors. Thanks.
MTD % Change.xlsm
Formatting of axis is applied to all axis labels, so you can not colour each label individually.
You can use dummy data series and their data labels to fake the labelling of the axis.
For this you need to add a calculated field to the table to produce data points for each coloured series.
The new series can be moved to secondary axis and changed to line chart. Then use the data label for each of the series to provided the differently coloured labels.
So possible but may not be practical.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks