Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create an auto updating excel chart?
I have moved over to excel 2007 and cannot work out how to create a chart
that updates automatically. Can anyone help ? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create an auto updating excel chart?
Option A: Use an Excel 2007 Table (like an Excel 2003 List on steroids) as
the data source. Option B: Use dynamic ranges as the source data: http://peltiertech.com/Excel/Charts/...umnChart1.html http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dave01" wrote in message ... I have moved over to excel 2007 and cannot work out how to create a chart that updates automatically. Can anyone help ? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create an auto updating excel chart?
I've been trying to understand your directions on your website for charting
the last 12 months dynamically and am having trouble translating it to my own needs. I understand pretty much what you are doing, but my situation is a little different. I have data comparing the same week (Mon.-Sat.) from 2007 to the one in 2008. Each week I have data (total call volume) for 6 lines of business. I want to create a cluster column bar chart with lines of business on the x-axis and call volume on the y-axis that shows both weeks and updates with new data for the previous week and the corresponding week from a year ago. Is this possible? "Jon Peltier" wrote: Option A: Use an Excel 2007 Table (like an Excel 2003 List on steroids) as the data source. Option B: Use dynamic ranges as the source data: http://peltiertech.com/Excel/Charts/...umnChart1.html http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dave01" wrote in message ... I have moved over to excel 2007 and cannot work out how to create a chart that updates automatically. Can anyone help ? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create an auto updating excel chart?
John,
Thanks for this post, between this forum and your Chart the last 12 months on your website, i was able to solve a problem for one of my coworkers. "Jon Peltier" wrote: Option A: Use an Excel 2007 Table (like an Excel 2003 List on steroids) as the data source. Option B: Use dynamic ranges as the source data: http://peltiertech.com/Excel/Charts/...umnChart1.html http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dave01" wrote in message ... I have moved over to excel 2007 and cannot work out how to create a chart that updates automatically. Can anyone help ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create auto updating data validation list from all worksheet names | Excel Worksheet Functions | |||
SharePoint-Excel Link Create Double Lines When Updating | Excel Discussion (Misc queries) | |||
Updating an excel chart on a webpage | Charts and Charting in Excel | |||
Can I create an auto update chart in a template | New Users to Excel | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |