Create chart based on calculated totals

  • Thread starter Thread starter songyy
  • Start date Start date
S

songyy

I want to create a chart based on the calculated totals.

My query out put is like this:

2003SalesTotal 2004 SalesTotal 2005SalesTotal 2006SalesTotal
$350 $550 $700
$800

How can I make a pie chart against these data?

Thanks in advance!

Eli
 
Thanks Duane, I tried the Chart Wizard, I have only one of those four
fields shown on the chart, not all four fields at once.

Elaine
 
You might be able to modify the chart after the fact or possibly change your
query to be more normalized and read like:
Year Sales
2003 350
2004 550
2005 700
2006 800
 
Thank you for answering my question Duane.The problems is that the
years are the fields of the query. If I can thansfer the fields into
the numbers of record, then I think I can get the chart work. But in
the table structure these are the fields, how can I turn the fields
into record sets?

Elaine
 
You can normalize your table structure using a union query.
SELECT 2003 As Year, 2003SalesTotal As Sales
FROM tblUnNormalized
UNION ALL
SELECT 2004, 2004SalesTotal
FROM tblUnNormalized
UNION ALL
SELECT 2005, 2005SalesTotal
FROM tblUnNormalized
UNION ALL
SELECT 2006, 2006SalesTotal
FROM tblUnNormalized;

You should consider normalizing your table structure so that you field names
don't store data values.
 
That does the trick! Thank yu duane! I have not used union query
before, I need to learn more about it!

Elaine
 
Duane:

Now I have a new problem. How can I have the chart show the value of
the SlaesTotal. My goal is to have it shown as a percentage, now I
can't even have it show the data as they are shown in the query.

Thank you for your help. You wrote back even in the weekend. I
appreciate it!

Elaine
 
I must have missed any suggestion of percentage in earlier posts. You can
change the "Data Series->Data Labels" to display "Percentage".
 
I can't find the place to make the changes as you indicated. But I
solved this problem by choosing the customer defined chart which happen
to have a chart which shows percentage. Lucky me!

Now how can I fit the whole chart into one page? I clicked on "Fit to
One Page", but it didn't do anything.

Thank you Duane, you are so helpful!

E
 
Never mind! I Got it!
E
I can't find the place to make the changes as you indicated. But I
solved this problem by choosing the customer defined chart which happen
to have a chart which shows percentage. Lucky me!

Now how can I fit the whole chart into one page? I clicked on "Fit to
One Page", but it didn't do anything.

Thank you Duane, you are so helpful!

E
Click to expand...
 
OK, here is what I did: when the report is in print view, right click
on "fit in one page", then it will adjust the page to fit in one oage.
By the way, I did find the place where Duane suggest to change the data
lable to "show percentage", but it is dimmed out, I can't click on it.

E
 
I'm not sure why the Show Percentage would be disabled. Is this a pie chart?
I would need to play around with the graph object in design to see what the
issue might be. You are in a better position to play with your chart than I
am.
 
Back
Top