Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 20
Default Percentage Axis: how should the scale look

I'm trying to scale my axis from 0 to 1.8% ascending increments would be 3 -
how should the rest of the scale look ?
Minimum:
Maximum: 1.8
Major unit: 3
Minor unit:
Cross: 0
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default Percentage Axis: how should the scale look

Maximum: 1.8% or 0.018
Major unit: 0.3% or 0.003
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Shevvie" wrote in message
...
I'm trying to scale my axis from 0 to 1.8% ascending increments would be
3 -
how should the rest of the scale look ?
Minimum:
Maximum: 1.8
Major unit: 3
Minor unit:
Cross: 0
Thanks



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 20
Default Percentage Axis: how should the scale look

This has worked to a degree but need to acheive the following ascending order:
1.8
1.5
1.3
1.0
0.9
0.6
0.3
0.0
What should go in the remaining fields of the scale, thanks

"Bernard Liengme" wrote:

Maximum: 1.8% or 0.018
Major unit: 0.3% or 0.003
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Shevvie" wrote in message
...
I'm trying to scale my axis from 0 to 1.8% ascending increments would be
3 -
how should the rest of the scale look ?
Minimum:
Maximum: 1.8
Major unit: 3
Minor unit:
Cross: 0
Thanks




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default Percentage Axis: how should the scale look

Your question is unclear to me. Why not send me a file with example and tell
me what you want to change.
Send to my private email (not to newsgroup) just remove TRUENORTH.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Shevvie" wrote in message
...
This has worked to a degree but need to acheive the following ascending
order:
1.8
1.5
1.3
1.0
0.9
0.6
0.3
0.0
What should go in the remaining fields of the scale, thanks

"Bernard Liengme" wrote:

Maximum: 1.8% or 0.018
Major unit: 0.3% or 0.003
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Shevvie" wrote in message
...
I'm trying to scale my axis from 0 to 1.8% ascending increments would
be
3 -
how should the rest of the scale look ?
Minimum:
Maximum: 1.8
Major unit: 3
Minor unit:
Cross: 0
Thanks






  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 20
Default Percentage Axis: how should the scale look

Can you send me you're email, I don't see it below, thanks

"Bernard Liengme" wrote:

Your question is unclear to me. Why not send me a file with example and tell
me what you want to change.
Send to my private email (not to newsgroup) just remove TRUENORTH.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Shevvie" wrote in message
...
This has worked to a degree but need to acheive the following ascending
order:
1.8
1.5
1.3
1.0
0.9
0.6
0.3
0.0
What should go in the remaining fields of the scale, thanks

"Bernard Liengme" wrote:

Maximum: 1.8% or 0.018
Major unit: 0.3% or 0.003
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Shevvie" wrote in message
...
I'm trying to scale my axis from 0 to 1.8% ascending increments would
be
3 -
how should the rest of the scale look ?
Minimum:
Maximum: 1.8
Major unit: 3
Minor unit:
Cross: 0
Thanks








  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default Percentage Axis: how should the scale look

First letter of first name
plus LIENGME
@
stfx
dot
ca

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Shevvie" wrote in message
...
Can you send me you're email, I don't see it below, thanks

"Bernard Liengme" wrote:

Your question is unclear to me. Why not send me a file with example and
tell
me what you want to change.
Send to my private email (not to newsgroup) just remove TRUENORTH.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Shevvie" wrote in message
...
This has worked to a degree but need to acheive the following ascending
order:
1.8
1.5
1.3
1.0
0.9
0.6
0.3
0.0
What should go in the remaining fields of the scale, thanks

"Bernard Liengme" wrote:

Maximum: 1.8% or 0.018
Major unit: 0.3% or 0.003
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Shevvie" wrote in message
...
I'm trying to scale my axis from 0 to 1.8% ascending increments
would
be
3 -
how should the rest of the scale look ?
Minimum:
Maximum: 1.8
Major unit: 3
Minor unit:
Cross: 0
Thanks








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to draw chart: log scale on X axis, natural scale on y axis? Pratap D. chavan Charts and Charting in Excel 1 November 16th 06 08:03 AM
How do I reference x-axis or y-axis scale values to a worksheet ce retro5726 Excel Discussion (Misc queries) 0 August 10th 06 01:46 AM
How to make Primary axis and Secondary X-axis have the same scale AdamCPTD Excel Discussion (Misc queries) 0 July 14th 06 02:14 PM
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit Pedant Charts and Charting in Excel 1 August 29th 05 03:50 AM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"