How to Create Chart in Access 2010

[braveali]

Greetings Friends!

I am very new in Access, I want to create a Bar Chart from a Query, but it doesn't show me the right chart as I wanted to:

Please have a look my Query our result:


and want it should show me like this (which i have created in Excel):




But MS Accessing Shows me the below graph




I will appreciate if someone please guide me how could I manage my chart in access so that I will show the Items on left side and bars on right side?

thanks

[June7]

Can you provide project? I analyze chart issues best when I can work with data.

[lglenn1816]

HI,

I am teaching access 2010 for the first time and also get the same results as posted above. How do I get my Access charts to properly read my data and not default to directional points (north, south, east west) and quarters?

Thank you,

Laura

[June7]

Do you get the correct chart output in Layout or Form view? Save the form (or report) when opened in Layout or Form (or Report) view. Then reopen in design view. Should see your data displayed.

[lglenn1816]

Hi,

I tried both report and form, in design view still get the same darn North, South, East and quarters. . .

[ItsMe]

I don't know anything about charts but, I would guess that the SQL for the chart object's RowSource property is no good. Maybe you are trying to use the sum() function on a field that does not allow sum().

[lglenn1816]

Good thought, but my test pie chart one was just one column of labels and a second of numbers that I typed in. . .

[ItsMe]

I am going to guess you will need at least two columns for your SELECT statement of the RowSource. At least one should be a number. The other could be text but, I do not know what a column of labels is. This does not sound like a good candidate for a field in your chart's RowSource.

[June7]

Want to provide db for analysis? Follow instructions at bottom of my post.