View Single Post
  #1   Report Post  
PK
 
Posts: n/a
Default Charting data against dates where dates are not at fixed intervals

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