Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,560
Default Pivot Chart Time Series work around?

i'm running with Excel 2002 sp2.
I'm now aware that a time series x-axis is not available in a pivot chart.
Maybe there's a way of getting pivot chart flexibility AND a time series
x-axis by other methods?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 38
Default Pivot Chart Time Series work around?

While you can't do a true XY scatter chart as a pivot chart, there are a
couple of options in 2007 that might work for you.
1) use a line chart, there is now support for date-based azes (check in
formatting if it has been correctly selected). This overcomes previous
limitations where data points were not spaced evenly, but does not
overcome issues if they are not sorted by date.
2) in a blank area of your worksheet, make a mirror copy or the
PivotTable as a straight =A3, =B3...,=A4... Either leave this dynamic
(best option) or copy paste special "values". Do your chart from this
copy, with no restrictions on type.

Hope this helps
Adam

On 18/02/2010 12:56, David wrote:
i'm running with Excel 2002 sp2.
I'm now aware that a time series x-axis is not available in a pivot chart.
Maybe there's a way of getting pivot chart flexibility AND a time series
x-axis by other methods?

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
Pivot Chart- 2 unrelated series on 1 chart toby131 Charts and Charting in Excel 4 October 23rd 09 05:05 AM
How can I make an Excel time series chart? MA Charts and Charting in Excel 1 January 29th 08 09:00 AM
Multiple chart series for Pivot Chart MJW[_2_] Charts and Charting in Excel 0 August 15th 07 08:16 PM
Chart a time series Eric Charts and Charting in Excel 1 March 18th 07 01:02 PM
new time series chart type Gklass Charts and Charting in Excel 3 June 23rd 06 02:30 PM


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