Prev: Filter on a date working on one PC not not another
Next: Outlook Read Receipt
From: Jeff on 27 May 2010 14:27
I have time-series values generated from a query; user refreshes a
PivotChart as they step through filters, and the PivotChart shows the
time-series trends. Typical use I think.

The query is sensitive to date formatting, and outputs m/d/yyyy in
correct datatype. Data resolution is to the day, with time series
extending to around 1902 to current -- and, of course, data density
varies a ton. Depending on the filter, might be twenty records only
between 1990 and current; others may query thousands of records over
70 years.

So I'm using a PivotChart chart type of Line ("Displays trend over
time or categories.") to show this them individually, but the x-axis
is killing me. It doesn't follow time rules, seems to be more like an
x-y scatter chart -- in other words the time-series axis scales to
data density instead of showing valid time-series changes.

I assume I have a setting wrong someplace, but I hope I can be
forgiven for not finding the interface entirely intuitive.

Any pointers? Seems like others have struggled with this, but the
InterTubes haven't yielded me good results as yet...

Thanks!
From: Jeff on 27 May 2010 15:45
Resolved -- changed the chart type back to X-Y Scatter, which forces
one to set a min/max X (bummer), but at least it shows the accurate
distributions. The lingering oddity in my mind is I have NO trouble
doing this with a line type chart object in Excel, and I thought the
OLE tool was the same in Access. But maybe that's different from the
PivotChart codebase - anyway, all's well ends well.

Cheers!

On May 27, 11:27 am, Jeff <jnorvi...(a)gmail.com> wrote:
> I have time-series values generated from a query; user refreshes a
> PivotChart as they step through filters, and the PivotChart shows the
> time-series trends.  Typical use I think.
>
> The query is sensitive to date formatting, and outputs m/d/yyyy in
> correct datatype.  Data resolution is to the day, with time series
> extending to around 1902 to current -- and, of course, data density
> varies a ton.  Depending on the filter, might be twenty records only
> between 1990 and current; others may query thousands of records over
> 70 years.
>
> So I'm using a PivotChart chart type of Line ("Displays trend over
> time or categories.") to show this them individually, but the x-axis
> is killing me.  It doesn't follow time rules, seems to be more like an
> x-y scatter chart -- in other words the time-series axis scales to
> data density instead of showing valid time-series changes.
>
> I assume I have a setting wrong someplace, but I hope I can be
> forgiven for not finding the interface entirely intuitive.
>
> Any pointers?  Seems like others have struggled with this, but the
> InterTubes haven't yielded me good results as yet...
>
> Thanks!

 | 
Pages: 1
Prev: Filter on a date working on one PC not not another
Next: Outlook Read Receipt