Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Need an Idea on Arranging Data for a Chart
I have an Access Database that has thousands of records in it. Each record
has the following fields (simplified): Date, Site, Seconds I have a workbook that wueries the database, and brings in data into a table for each site that has the Date and Seconds on each line of the table. I would like to graph the data, based on groupings that the user will choose, so maybe they would like to each data point on the line be the average for a week, and the line would show 10 weeks, etc. What I am struggling with is how to get from the frist table, to one that is grouped by day, or week, or month or qrtr, etc. in an automated way. Anyone have any ideas/examples they could share? I've gotta belive that this has been done before, and I am just overlooking the obvious. Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Need an Idea on Arranging Data for a Chart
Dump the data into a worksheet, and define a named range that includes all
of the data. Something like Insert menu Names Define dialog Name: PT_DataBase RefersTo: =Offset(DataSheet!$A$1,0,0,COUNTA(DataSheet!$A:$A) ,COUNTA(DataSheet!$1:$1)) Then make a pivot table, using this defined name as the source data range, and group dates as appropriate. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Steve Haack" wrote in message ... I have an Access Database that has thousands of records in it. Each record has the following fields (simplified): Date, Site, Seconds I have a workbook that wueries the database, and brings in data into a table for each site that has the Date and Seconds on each line of the table. I would like to graph the data, based on groupings that the user will choose, so maybe they would like to each data point on the line be the average for a week, and the line would show 10 weeks, etc. What I am struggling with is how to get from the frist table, to one that is grouped by day, or week, or month or qrtr, etc. in an automated way. Anyone have any ideas/examples they could share? I've gotta belive that this has been done before, and I am just overlooking the obvious. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Idea on Arranging Data for Chart | Excel Discussion (Misc queries) | |||
Chart: Need idea to display (Z axis) | Excel Discussion (Misc queries) | |||
Arranging information so a chart makes sense | Charts and Charting in Excel | |||
Need help arranging chart | Excel Discussion (Misc queries) | |||
How do i rearrange pie chart without re-arranging source table? | Charts and Charting in Excel |