#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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Pivot Chart Y Axis

In a pivot chart, the best bet is to plot the pairs on primary and secondary
axes. Double click one of the small-valued series, and on the Axis tab,
select Secondary. Select the other small-valued series and click F4 to
repeat.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Neil" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 173
Default Pivot Chart Y Axis

Thanks Jon that does work but the only problem is that i have the pivot on
different days and when i swap between the days it changes back to all being
on the primary axis. I also had this when i changed the thickness of the line
on the line chart. Is there any way of making this permanant? I have saved it
but still no joy

Many thanks

"Jon Peltier" wrote:

In a pivot chart, the best bet is to plot the pairs on primary and secondary
axes. Double click one of the small-valued series, and on the Axis tab,
select Secondary. Select the other small-valued series and click F4 to
repeat.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Neil" wrote in message
...
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




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Pivot Chart Y Axis

Pivot charts lose all customization when the table is pivoted. You could do
is record a macro while you fix the formatting, then rerun the macro when
needed. Or you could make a regular chart of the pivot data, if the pivot
table doesn't change its size when you change the date range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Neil" wrote in message
...
Thanks Jon that does work but the only problem is that i have the pivot on
different days and when i swap between the days it changes back to all
being
on the primary axis. I also had this when i changed the thickness of the
line
on the line chart. Is there any way of making this permanant? I have saved
it
but still no joy

Many thanks

"Jon Peltier" wrote:

In a pivot chart, the best bet is to plot the pairs on primary and
secondary
axes. Double click one of the small-valued series, and on the Axis tab,
select Secondary. Select the other small-valued series and click F4 to
repeat.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Neil" wrote in message
...
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






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
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 11:04 PM


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