ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Formatting in bar chart axis (https://www.excelbanter.com/charts-charting-excel/171049-formatting-bar-chart-axis.html)

Junkyard Engineer

Formatting in bar chart axis
 
When trying to format my bar chart axis labels (categories), the formatting
applies to all labels. Even if in my data series, the specific labels are
formatted differently (i.e. bold+red), on the graph they all appear the
same.

Is there a way to edit/format one axis label and not the others ?


Andy Pope

Formatting in bar chart axis
 
Hi,

Formating of axis labels will apply to ALL labels. You can not format
individual labels.
As a work around you can create your own labels using an extra series
and data labels. For more information have a look at these pages.
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Cheers
Andy

Junkyard Engineer wrote:
When trying to format my bar chart axis labels (categories), the
formatting applies to all labels. Even if in my data series, the
specific labels are formatted differently (i.e. bold+red), on the graph
they all appear the same.

Is there a way to edit/format one axis label and not the others ?



All times are GMT +1. The time now is 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com