Dynamic Charts in Reports

Zempten

Board Regular
Joined
Apr 21, 2014
Messages
55
Hello

I've been trying to put charts in my reports for awhile now but without much success. I have a query that pulls from the main table the amount of time it took to load a truck based on a range of dates. Once I have the query run, I use that query to build a chart in my report. The problem occurs when I try to change to a different range of dates but my chart only shows the last date range.

As an example:
Run my query with dates 8/1 to 8/15
Place chart into report
Run my query with dates 8/16 to 8/30
Chart still only shows dates 8/1 to 8/15

How do I make my chart data change with how I change my date range? I was able to use a pivot chart that would change dynamically to how my query changes (with the changing date range), but I cannot seem to put a pivot chart into a report. Is there anyway to get my chart to update with how I change my query dates?
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
2,172
Your query should be looking at the form to get the dates say...txtDateStart, and txtDateEnd
The query should be
select * from table where [date] between forms!frmRpt!txtDateStart and forms!frmRpt!txtDateEnd

The report will use this query and it WILL change as the dates change.
If not, its possible your chart is not mapped to the dates in the query.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,115
Messages
5,835,471
Members
430,358
Latest member
zzc1128

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top