Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom Format numbers for learning chart
Hi,
xlsx 2007 I have a line chart with vertical axes as follows.. Primary scale : from 0 to 10000 Secondary scale : from 0 to 80,000 Both scale are used for many lines. I like to introduce another line (e.g. learn curve) which is not to be covered by the two vert axes' scale; I have a series of value with 7 figures (e.g. 1,000,000 ; 2,000,200 ; 5,010,123) I have this series anew in_line with the secondary axis by dividing each figures by 100 (e.g. 10,000 ; 20,002 ; 50,101.23). No sweat.. --- However, I like the points along this line to be labeled with formatted numbers (e.g $1.0M ; $2.0M ; $5.01M) I tried to custom format the new series but can't find the simple trick to tweak the format. Is there a custom format ? thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom format Numbers | Excel Discussion (Misc queries) | |||
Custom format numbers | Excel Discussion (Misc queries) | |||
Custom Format Numbers to $$ | Excel Discussion (Misc queries) | |||
Custom Format for Numbers | Excel Discussion (Misc queries) | |||
How to format text and numbers as custom | Excel Discussion (Misc queries) |