Ok trying to attach a Pivot Chart (generated from a query) to the end of a report that is sent as PDF each morning.
I tried using the stupid Chart Wizard in the report design view, but it is always messed up and I cant get the formatting of the chart( series colors, data labels formats, all that stuff) to stick and look how I want. Then when in design view it just shows that generic stuff so I dont know exactly what I'm changing.
It is a simple query it only has a catergory and a percentage. I just want these represented in a chart form. Below is data and How I want the graph to look. The data will change daily since the query is ran everyday at 7:00 am and produces this graph as well as an existing report.
Category Availabily Precentage 1 -TRUCK 70.41% 2 - SCALER 70.74% 3 - DRILL 97.15% 4 - LHD 79.11% 5 - BOLTER 80:00% ![]()
I want that graph to be on page 2 of this report.
This report is used each morning to discuss the current state of equipment and discuss yesterdays numbers.
Any help with this is greatly appreciated.