Hello hello, I was wondering if someone could help me with this piechart issue.
So I have a query that basically holds:
Query2 Food Query Store Food Amount #1 Apple 20 #1 Oranges 10 #1 Peaches 30 #2 Apple 10 #2 Oranges 10 #3 Apple 4 #3 Oranges 5 #3 Peaches 6
So, I'm trying to make a pie chart from this, and I want it to look like...
(Click for larger picture)
But what I'm getting is...
I made the first picture by creating 3 individual reports for each Store Name, but since the store name will vary, I can't do it that way. Any ideas?
So I have a query that basically holds:
Query2 Food Query Store Food Amount #1 Apple 20 #1 Oranges 10 #1 Peaches 30 #2 Apple 10 #2 Oranges 10 #3 Apple 4 #3 Oranges 5 #3 Peaches 6
So, I'm trying to make a pie chart from this, and I want it to look like...
(Click for larger picture)
But what I'm getting is...
I made the first picture by creating 3 individual reports for each Store Name, but since the store name will vary, I can't do it that way. Any ideas?
