ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I convert numbers on an axis to text? Ex - 480 = Mon D; 7 (https://www.excelbanter.com/charts-charting-excel/262873-how-can-i-convert-numbers-axis-text-ex-480-%3D-mon-d%3B-7-a.html)

Melvin Sullivan

How can I convert numbers on an axis to text? Ex - 480 = Mon D; 7
 
Graph is based on shifts of 480 min each and 3 shifts per day. Graph covers
1 week. So I want to show 480, 960, etc. - which it does.

But how can I also have 480 = Mon - D; 960 = Mon - A (D=days; A=afternoons).

Thank you.

Bernard Liengme[_2_]

How can I convert numbers on an axis to text? Ex - 480 = Mon D; 7
 
Have a look at Andy Pope's chart labeller add-in
http://www.appspro.com/Utilities/ChartLabeler.htm
Is mention XY charts but works for all types
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Melvin Sullivan" <Melvin wrote in
message ...
Graph is based on shifts of 480 min each and 3 shifts per day. Graph
covers
1 week. So I want to show 480, 960, etc. - which it does.

But how can I also have 480 = Mon - D; 960 = Mon - A (D=days;
A=afternoons).

Thank you.




All times are GMT +1. The time now is 09:04 AM.

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