"Tushar Mehta" wrote in message
m...
Did you try the default chart that XL creates based on your PivotTable?
Once you have that, if it is not already a Line chart, change the type
(select the chart, then Chart | Chart Type...). If the x-values are
not correctly spaced, click the chart then Chart | Chart Options... |
Axes tab. In there set the type of the x-axis to 'Time scale'.
Tushar, this did not work ... it changed all my dates from e.g. 1/26/2004 to
1/1/1900 and the next date to 1/2/1900 (IIRC) - I think it just took the
'category number' and made it a date.
Regards,
PK
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <fM1re.313257$cg1.237772@bgtnsc04-
news.ops.worldnet.att.net, says...
I have several data points that are the result of a pivot-table and I'm
trying to plot them in a pivot-chart (I can easily get them out of the
pivot
table if the graph format is not supported for pivot-charts). Here's an
example of the data:
2005/01/15 2005/02/22 2005/03/18 2005/05/20
X 16 18 22 12
Y 4 6 3 2
Z 14 19 12 34
What I'd like to do is plot the data (preferably on a line chart) such
that
the dates are on the x-axis and spaced as they would be on a calendar and
not simply as 4 points on a chart. e.g. in the example above there would
be
4 points per category but the points would be at varying intervals on the
date axis as they are not equidistant in time. Is this possible?
All help appreciated?
Regards,
PK