Microsoft Access 2003 Chart

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I am trying to create a chart with a legend in a report.
The fields that I am using have a Yes/No Data Type. The
legend displays a -1 & 0 for the description of the bars
in the chart. I want to change the names of these
descriptions to Software & Physical. Can anyone tell me
how to do this? I've been working on this for days and
am getting really frustrated.

Thanks,
Ron
 
Ron said:
I am trying to create a chart with a legend in a report.
The fields that I am using have a Yes/No Data Type. The
legend displays a -1 & 0 for the description of the bars
in the chart. I want to change the names of these
descriptions to Software & Physical. Can anyone tell me
how to do this? I've been working on this for days and
am getting really frustrated.
Click to expand...

I've gotten frustrated with Access charting as well. I no longer even
bother. Even though Access uses the same charting engine as Excel, Excel
implements it so much better. OK, I'm not a masochist, I just use Excel.

Output your data to a named range in Excel then build a chart in Excel.
There's a method in Excel that will output the chart as a gif or jpg, I use
that to create an image file which is then reused in an Access image
control. Here's a snippet of code that does that:


Set chtXL = wks.ChartObjects(1).Chart
chtXL.Export FileName:=strPath, FilterName:="GIF"

Me.imgControl.Picture = strPath

Although this code snippet is devoid of Dim'ing the variables, filling the
range, error handling, etc, you should be able to get the syntax required.
Excel should make it easy enough to customize your chart.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top