Modifying Charts in Access Reports

  • Thread starter Thread starter psdcc
  • Start date Start date
P

psdcc

There was a post earlier titled "Only 6 Data sets." Similarly, I can
create a chart that works well but it only allows for 6 fields to be
included for the chart. I would like to increase the number but I
can't sort out how to make changes.

When I double click on the chart, I am taken to the Chart editor and I
can seemingly make aesthetic changes. However, when I view the report
none of the color changes take effect and I'm not sure how to include
new fields. ANY help would be greatly appreciated!!

Resedu
 
Well, with some monkeying around, I've managed to add fields to the
graph and it works well. However, I have an additional question.

I currently have a bar graph for 7 fields. I would like to overlay the
average for each field as a line, so that the customers can have an
idea of how they compare. The average would be a constant...if I
double click on the graph and add a new row, inserting the constant, I
get exactly what I am looking for. However, when I exit and preview
the graph, those changes aren't carried over. Does anyone have any
suggestions on how I might achieve this?

Cheers,
Resedu
 
Back
Top