Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 90
Default Scale Question regarding 0

My chart is not very clear at this time.

I have a few items of data A, B, C, and D.

A has 250 of X.
B has 30 of X.
C has 0 of X.
D has 1 of X.

Since 250 is such a large difference from 1, D is almost non-existent. Is
there any way to increase the view size of 1?

Microsoft 2003.

Live User


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Scale Question regarding 0

Hi,

One way would be to break the Value axis.
For work around instructions see
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Cheers
Andy

LiveUser wrote:
My chart is not very clear at this time.

I have a few items of data A, B, C, and D.

A has 250 of X.
B has 30 of X.
C has 0 of X.
D has 1 of X.

Since 250 is such a large difference from 1, D is almost non-existent. Is
there any way to increase the view size of 1?

Microsoft 2003.

Live User



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
LOG SCALE log scale on clustered bar graph with Charts and Charting in Excel 1 October 24th 07 09:51 AM
3D Stacked column - scale question sahafi Charts and Charting in Excel 5 July 5th 07 05:51 PM
Using "if" function to translate 100 scale into 4.0 scale Robert McN Excel Worksheet Functions 2 May 10th 07 04:57 AM
Sliding scale Question Sandy Excel Worksheet Functions 1 April 14th 07 12:28 PM
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


All times are GMT +1. The time now is 08:19 PM.

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

About Us

"It's about Microsoft Excel"