If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Line Chart Trouble
I have a query which calculates a percentage based on 2 values. So I have 4
columns in my query: Week Ending Date, Drops, Calls, Calls2Drop The query is grouped by week ending date, includes the sum of drops and the sum of calls, and a percentage that is Calls2Drop(which is SumOfCalls/SumOfDrops). Simple. Now I am trying to create a line chart with Week Ending Date being the x-axis and the Calls2Drop percent as the value. All it will let me use is Count(Calls2Drop). I just want the exact value from the query represented on the chart, not a count of the values. When I try to change the SQL to only include Calls2Drop instead of Count(Calls2Drop) it tells me it is not part of an aggregate function in the query. Why should it have to be? How do I get around this? Any help is appreciated. |
#2
|
|||
|
|||
Line Chart Trouble
Please provide the SQL view of your chart's Row Source.
-- Duane Hookom MS Access MVP "This Guy" wrote in message ... I have a query which calculates a percentage based on 2 values. So I have 4 columns in my query: Week Ending Date, Drops, Calls, Calls2Drop The query is grouped by week ending date, includes the sum of drops and the sum of calls, and a percentage that is Calls2Drop(which is SumOfCalls/SumOfDrops). Simple. Now I am trying to create a line chart with Week Ending Date being the x-axis and the Calls2Drop percent as the value. All it will let me use is Count(Calls2Drop). I just want the exact value from the query represented on the chart, not a count of the values. When I try to change the SQL to only include Calls2Drop instead of Count(Calls2Drop) it tells me it is not part of an aggregate function in the query. Why should it have to be? How do I get around this? Any help is appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a line chart with two X-axes!! | JaVaughn | General Discussion | 1 | June 30th, 2005 01:36 PM |
Line chart - date line association gone mad! | Johannes Czernin | Charts and Charting | 5 | January 17th, 2005 08:48 PM |
Line chart | gibasse | Charts and Charting | 4 | April 8th, 2004 04:18 PM |
Trying To Add a Line to an Excel chart using variable cell values | Larry Campbell | Charts and Charting | 2 | January 24th, 2004 05:31 PM |
Plotting a datapoint on an existing Line chart | Tushar Mehta | Charts and Charting | 0 | November 23rd, 2003 01:08 AM |