Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Information
Using Excel and Access 2003 on an XP SP2 machine.
Is there a way to produce a pie chart from an Access query when you will not always have the same fields return results to be plotted? (In case that was as clear as mud to you as it was to me, I'll try to explain.) I know how to return reqults from a query to a spreadsheet and produce a chart from there. What has me stumped is what to do when the fields change. For instance, I'm trying to produce a pie chart that will show how many of several different categories of data occur. However, depending on what transpires during a reporting period, I may not have records for each. For example, this week the query returns: A=5 B=3 C=6 D=4 Next week, there may not be any "C" occurences. So, when the spreadsheet is opened and the data automatically refreshes, there will be one less row of results returned, skewing the chart. Also, As this dayabase is just starting out, there currently aren't any "E" occurences, so when those hit it will add another row of results. So, any advice on how to set this up? Thanks in advance. -- John Cello John Cello Consulting Helping organizations hire, develop, and retain their best employees. www.johncelloconsulting.com |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Information
You could set up a dynamic range that encompasses the query results, and use
this as your chart's source data. Links and examples: http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "John Cello" (nospam) wrote in message ... Using Excel and Access 2003 on an XP SP2 machine. Is there a way to produce a pie chart from an Access query when you will not always have the same fields return results to be plotted? (In case that was as clear as mud to you as it was to me, I'll try to explain.) I know how to return reqults from a query to a spreadsheet and produce a chart from there. What has me stumped is what to do when the fields change. For instance, I'm trying to produce a pie chart that will show how many of several different categories of data occur. However, depending on what transpires during a reporting period, I may not have records for each. For example, this week the query returns: A=5 B=3 C=6 D=4 Next week, there may not be any "C" occurences. So, when the spreadsheet is opened and the data automatically refreshes, there will be one less row of results returned, skewing the chart. Also, As this dayabase is just starting out, there currently aren't any "E" occurences, so when those hit it will add another row of results. So, any advice on how to set this up? Thanks in advance. -- John Cello John Cello Consulting Helping organizations hire, develop, and retain their best employees. www.johncelloconsulting.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically changing cell information | Excel Discussion (Misc queries) | |||
changing a cell to changing the link | Excel Worksheet Functions | |||
LOOK UP INFORMATION | Excel Worksheet Functions | |||
Changing series information for approximately 60 series in a workb | Charts and Charting in Excel | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) |