Chart Help

[derrickchanson]

Hello,

I'm getting an error when I'm trying to create a chart. The chart is based on a query with the following data:

Month Campaign Sales
1/2005 A 100
1/2005 B 200
2/2005 A 250
2/2005 B 300

I want the chart to show "Sales" on the Y axis and "month" on X axis. I want sales totaled for each month and I want a separate line for each "Campaign". Here is the code that appears in the row source when I use the chart wizard:

TRANSFORM Sum([Incr$_Store]) AS [SumOfIncr$_Store] SELECT [Month] FROM [qryAnnual_Performance_Trend_4] GROUP BY [Month] PIVOT [Campaign];

Thanks
Derrick

 

[PCLewis]

Change the PIVOT then

TRANSFORM Sum([Incr$_Store]) AS [SumOfIncr$_Store] SELECT [Campaign] FROM [qryAnnual_Performance_Trend_4]   GROUP BY [Campaign] PIVOT [Month];