help with charts

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

Hey, I need help with a chart. I have this data that has
four columns, system, month, response time and volume. I
need to create a chart that has month as x axis and
response time and volume as the y axis. I am using ms
access 2000 and it won't allow me to create two y axis.
see I need two columns going straight up(y axis) by month
for the particular month. I am stumped.
 
You might want to try to have two charts either side by side or one above
the other in a report.

Chart 1 has Month and Volume
Chart 2 has Month and Response Time

For aesthetics, you should create Chart 1 first and make all the visual
changes you need (scale, colors, etc). Then duplicate Chart 1 and modify the
row source to get Chart 2. Then both charts would be the same size/color,
etc.

Another option would be to come up with a creative formula so that Volume
and Response Time can use the same scale. (Like in architectural drawings,
where 1in on paper = 8 ft in real life).

Cameo
 
Back
Top