• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1000
  • Last Modified:

MS Access Chart Formatting

In the sample database I have Sample Report which is the graph I want to modify, the graph data is a crosstab query based on the Sample Query.

What I would like to do is add a horizontal line in the graph to plot the flat Facility Avg Index, on the line I want to have the text “Facility Average 2.02, Total Equipment Count 253”, and the Facility Average and Total Equipment Counts should not appear in the chart legend.  I’d also like to allow the Y axis scale to auto scale the max value based on the Area Avg Index, currently it scales on the largest value of Area EQ Count, but these values I only want to show in the legend not in the actual graph.  What I did to hide the column in the chart was to set its board and back color to white.

I’ve read a few tricks to do these things in excel but I need to do them in Access 2007.  Any help is appreciated.

Thanks in advance,
Jim
SampleDB.mdb
0
phonepagerfax
Asked:
phonepagerfax
  • 2
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
Lets keep it simple...
Forget complex descriptions...
Just post a detailed graphic of the exact output you need...
;-)

<I’d also like to allow the Y axis scale to auto scale the max value based on the Area Avg Index, currently it scales on the largest value of Area EQ Count,>
This cannot (AFAIK) be done, unless you  use the "averages" as the values on which the chart is based...
...but lets keep this to one question per post, (as per the rules of this site) and just focus this thread on the "Line" you want...
Sound fair?
;-)

JeffCoachman
0
 
phonepagerfaxAuthor Commented:
Jeff,

Here is a sample chart.

Thanks,

Jim
Sample-Graph.bmp
0
 
Jeffrey CoachmanCommented:
Unfortunately, I could not replicate your chart fully because the Rowsource could not execute:

error
But in a nutshell, you need to add the "total Average" (2.02) to the charts Rowsource.
See my attached sample.

Note that there is no easy way to add a series to the rowsource (Area EQ Count) and not have it appear as a series on the graph.
It is alternatively tricky to "remove" series from the graph, but still have it appear on the data table.

So you will have to take what I did here to get the "Average For All", and adapt it to your chart to get the final output you are looking for here.
SampleDB.mdb
0
 
phonepagerfaxAuthor Commented:
Thank you all for your help.

Jeff – from now on I’ll make sure to have only one question per post…

boag2000 – although, your example did not create the chart I was looking for it was very helpful in designing my final solution.

In the end I created a temp table to hold the values I needed to graph, I removed the overall average from a line to just another series in the column chart.  One promising feature I found in Excel that may come in handy in the future is the ability to change the chart type for a series so, a column chart can plot a single or multiple series in that chart as a line chart type…

Thanks,

Jim
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now