Pivot Charts

B

Beth McLaren

I am working on some Pivot Charts and would like to graph something off a
query that is currently pulling my 'DAYS DIFFERENCE' (designed as an
expression calculatin) in but is looking at a 'GOAL' value which I have set
up as a default value in a table as '30' - Access brings it into the
PIvotChart calling it 'COUNT OF GOAL' and appears to be counting it as 1 goal
rather than taking the defualt value I have given it and graphing alongside
the DAYS DIFFERENCE as a comparison...is there a way that this can be
corrected?
 

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

consolidate charts from multiple pivot tables 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Chart Type changes when I pivot 1
Occasional meter readings chart 0
Chart SERIES OFFSET 5
Multi Axis Pivot Chart 12
Pivot Charts 0
Multiple chart series for Pivot Chart 0

Top