Charts

[JD316632]

Never had much luck with the charts in Access, what better time to learn then now?

I have a query that in Column A: has a sum of the number of phone calls and column b has the total number of times the phone call had documentation logged, I want to take and compare them in a pie chart but when I create the pie chart I can only see the total from Column A, it doesn't compare Column A vs. Column B

Any help is greatly appreciated!

 

[GaryPanic]

i wish i could help- i stumble when doing charts in access - i do mine by trial and error (more error than anytihng else)

i presume you tried the chart wizard
look at lesbans site see if that can help.
..

 

[JD316632]

i wish i could help- i stumble when doing charts in access - i do mine by trial and error (more error than anytihng else)

i presume you tried the chart wizard
look at lesbans site see if that can help.
..

Not seeing anything there for charts.

I have the numbers I need, its just a matter of placing the data in the chart. From the looks of it, I can only compare numbers in a column, not multiple columns.

 

[GaryPanic]

if you figure this out - let me know

regards

 

[JD316632]

Anyone have any input?

 

[GaryPanic]

this is as far as I have got with charts - have a look see if it helps

Access 2000

 

[JD316632]

this is as far as I have got with charts - have a look see if it helps

Access 2000

Actually what I've done is used a macro using TransferSpreadsheet, then link the chart via unbound object frame. It's the only way I could get it to work, and the charts look much nicer in Excel than Access.