Modifying Charts in Access Reports

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
 
R

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
 
Top