C
Clinton Wolfe
Is there any way to create a numerical/continuous X axis using a Pivot chart
(not a categorical axis, like it creates by default?)
The problem I have is something like this: I have a table with two columns:
time, and sampled_value. The rows are not evenly spaced, time-wise - I may
have a value at 3:05 PM, none at 3:10, and one at 3:15PM. I want to chart
the data with an evenly-spaced X axis - so it goes 3:05, 3:10, 3:15, showing
no data (or zero) for 3:10.
But as-is, so far as I can tell, Access always treats it as categorical data
- so there is a 3:05 category and a 3:15 category, but no 3:10 category.
The only way around this that I have found is to create a dummy table with
"all times" - 3:00, 3:05, 3:10, 3:15, etc - and then make a query that does a
LEFT OUTER JOIN between the all_times table and the real data table. But
this is awful - all_times should be inifinitely large, and my data is
generally pretty sparse..... and there has just got to be a better way.
Ideas?
(not a categorical axis, like it creates by default?)
The problem I have is something like this: I have a table with two columns:
time, and sampled_value. The rows are not evenly spaced, time-wise - I may
have a value at 3:05 PM, none at 3:10, and one at 3:15PM. I want to chart
the data with an evenly-spaced X axis - so it goes 3:05, 3:10, 3:15, showing
no data (or zero) for 3:10.
But as-is, so far as I can tell, Access always treats it as categorical data
- so there is a 3:05 category and a 3:15 category, but no 3:10 category.
The only way around this that I have found is to create a dummy table with
"all times" - 3:00, 3:05, 3:10, 3:15, etc - and then make a query that does a
LEFT OUTER JOIN between the all_times table and the real data table. But
this is awful - all_times should be inifinitely large, and my data is
generally pretty sparse..... and there has just got to be a better way.
Ideas?