LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 173
Default Pivot Chart Y Axis

Hello

I have a Pivot table with 4 different kinds of data on. Two sets of the data
are in the 500-900 range and the other two are 5-10 range and 30-50 range. I
have these set as a line chart so i can can compare the data over differnet
weeks. But with this weighting it makes the lower value ranges harder to see
clearly. Is there a way i can change the Y Axis to ditch say 200-400 and
bring tham closer together.

I Hope this makes sense

Thanks
 
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
chart from pivot data does not update x-axis bar chart values - bug jason gers Excel Discussion (Misc queries) 0 April 3rd 07 06:34 PM
How to sort x-axis in pivot chart hstijnen Charts and Charting in Excel 0 September 22nd 06 01:13 PM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
Pivot Chart - Formatting Axis on Data Table Max Charts and Charting in Excel 1 May 19th 05 01:15 PM
Perserving secondary axis in pivot chart David Charts and Charting in Excel 1 January 28th 05 10:04 PM


All times are GMT +1. The time now is 11:48 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"