chart

  • Thread starter Thread starter Suzette
  • Start date Start date
S

Suzette

Hi,

Access 2000

I am trying to insert a chart into a report. It's weird because when I use
the wizard, it shows the chart just like what I want.

I have two values to compare.

Value A = 1,000
Value B = 735

If I do a preview in the wizard, it shows two bars (3d bar chart). One blue
for value A, one purple for value B (defaults on colors). Terrific! The
bars are next to each other. Life is grand. When I finish, and look at the
actual thing, it shows the two bars, same color as if it's two values of the
same thing. In looking at the default when you edit the chart, the values
are columns. I can't get them to be rows but I want to have them be as if
they were rows. Any ideas?

Thanks

Also... related. Every time I start to work with the chart, my Office
(2000) installer comes up and wants to run. It doesn't do anything, if I
cancel, it still works. Any suggestions?

Thanks for this too

Pulling my hair out.

Sue
 
Hi Suzette,

I've found that I have better luck if I use a table to create he chart rather than a query. Just make a copy of your query and turn it into a make table query.
Use the table it creates for the chart
 
Back
Top