PC Review


Reply
Thread Tools Rate Thread

How can I convert numbers on an axis to text? Ex - 480 = Mon D; 7

 
 
Melvin Sullivan
Guest
Posts: n/a
 
      30th Apr 2010
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.
 
Reply With Quote
 
 
 
 
Bernard Liengme
Guest
Posts: n/a
 
      30th Apr 2010
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 (E-Mail Removed)> wrote in
message news:174597D0-7C0C-4A4C-B30B-(E-Mail Removed)...
> 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.


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert X-axis in a Gannt chart to numbers hans L Microsoft Excel Charting 8 15th May 2010 08:29 PM
Can I convert numbers stored as text back to numbers in MS Access CUserM Microsoft Access Queries 7 20th Jun 2008 08:12 PM
Convert X-Axis Scale from Day/Month/Year Options to Actual Numbers =?Utf-8?B?Q0pNSVRDSEVMTA==?= Microsoft Excel Charting 2 31st Jul 2007 01:02 AM
Convert numbers stored as text to numbers errors after loading data in jobs Microsoft Excel Programming 2 28th Mar 2007 02:57 AM
Convert numbers stored as text to numbers Excel 2000 =?Utf-8?B?RGFybGVuZQ==?= Microsoft Excel Misc 6 31st Jan 2006 08:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:32 PM.