Chart X Axis = Date - Problem

G

Guest

Creating a chart within a report.
Charting X-Axis = a date, Y-Axis = a furness temperature.
The dates are not consecutive i.e. only log dates the furness was in use on
the table
The chart shows a column for all possible dates between the earliest and
latest date in the date range and not only the date records on the table.
Is it possible only to chart the dates found on the table ?

regards
 
D

Duane Hookom

Modify the Row Source query of the chart to only return records where there
is a furness temperature.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove the weekends from a pivot chart x axis 0
Multi Axis Pivot Chart 12
Chart with long X-axis 1
Line Chart - Problems with labeling X-Axis 3
Using text as data? 0
Reversing Dates Sequence along X axis in a chart 3
How to draw a graph with the X axis as a time line of date. 4
create chart with column axis 10

Top