Access Charts, do they actually exist? 2

[misscrf]

I am trying to make a statistical report, and would like a chart to go with it. I had such trouble with the Access (Microsoft Graph thingy) that I tried to make the chart in excel. I love doing them in excel.

Problem is that I am grabbing the data from Access, with a query to excel, and then inserting the excel chart back into an Access report.

I wouldn't mind that, but the chart doesn't refresh even though I have it linked.

So, back to Access?

The chart tool makes you sum some thing. I just want count of office by office. There is no summing to do there.

If anyone can help, I would appreciate it.

Thanks.

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[dhookom]

Just set the Row Source of the Chart Control to the values you want to chart. Don't worry about the wizard.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[misscrf]

Thank you for replying. I tried this, but I had problems.

The row source will change. It needs to be set to a query. Can it do that?


misscrf

It is never too late to become what you could have been ~ George Eliot

 

[dhookom]

Row Sources almost always change based on a date range or some other requirements. The Row Source is much like the Record Source of a subreport.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[misscrf]

Thank you dhookom. I'm sorry I havent gotten back to you. I was working on other improvements to my db. My confusion when it comes to Access charts is vast. I dont understand how the row source of a chart can be set, like say, to a query. That is what I want, but I am just not sure how to do it.

Let me try to summarize what I want to show.

100 people apply for a job with my company.

I want a chart of how many applied to what office.

So a chart by office, showing a count of candidates.

Then the same by application source ( email, walkin, monster.com)

Then the same by the department they applied to - IT, finance, HR.

and so on. I think the report would be about 4-5 charts.

Ideally the user would be able to pick a date range, but setting all this up is making my head spin. I only know how to do charts in excel.

If you can help me to how I can better learn Access charts, I would be interested to try.

Thanks.

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[MichaelRed]

a bit off center, but actually the Access & Excel (and other office apps) all use the same charting "applet". The only differnces are in the exposed interface elements. If you look into most any of the better tutorials (third party references?) re Ms. A. you can get a good introduction to the properties and methods and through these, the ability to do myuch more with the graph/chart than with the 'canned' interface which Excel uses.



MichaelRed

 

[dhookom]

misscrf,
Create and save a totals query with the exact data you want to chart. Then create a new report using the chart/graph wizard. Select your totals query as the row source for the chart.

You can always muck around in the chart design after the wizard has completed.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[misscrf]

Thank you all for responding. I actually figured it out! I did exactly what you said, Duane, and used my totals queries. I realized that the row should also be the series, from the wizard. That makes it cross tab.

My only limitation seems to be that I have 4 charts on a report, and I can only make the detail so long. Anyway, My next step is to try to add a control source to the report that they sit in, to give a date range to the charts.

I will probably report back when I get that going, if I run into any issues.

Thanks again.

misscrf

It is never too late to become what you could have been ~ George Eliot