Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I update my charts x axis (dates) automatically with new d
I have 2 questions and really need your help 1.I have data sheet and chart sheet.I am not using pivot table.For each new day I am adding one line for current day data to data sheet.I have around 60 charts.How can I get charts updated automatically.I am currently selecting each chart and extend data for adding one more line everyday to those 60 plots.(right click -selecting data and one more row from table) and it takes a lot of time. 2.Is there anyway to embed bubble (comment) data to specific date in axis.I have comments in bubbles for each day but they are shifting when I put new day's data.So I need to shift back them to the correct location(date) everyday. Thanks in advance! -- KHAN |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I update my charts x axis (dates) automatically with new d
EXCEL 2007
€œHow can I get charts updated automatically.€ You need to create Tables for your underlying data. I have just put up a chart to illustrate how this is done at:- http://www.pierrefondes.com/ Item number 104 (Dynamic Range Chart). This is an example of one way in which you might achieve your objective. If you look at the Worksheet I have put up step by step instructions (starting at cell D 24) as to how to add the Table. You can then add a further 2 rows of data (following my numbered instructions) and you will see the Chart update automatically. If my comments have helped please hit Yes. Thanks. "KHAN" wrote: I have 2 questions and really need your help 1.I have data sheet and chart sheet.I am not using pivot table.For each new day I am adding one line for current day data to data sheet.I have around 60 charts.How can I get charts updated automatically.I am currently selecting each chart and extend data for adding one more line everyday to those 60 plots.(right click -selecting data and one more row from table) and it takes a lot of time. 2.Is there anyway to embed bubble (comment) data to specific date in axis.I have comments in bubbles for each day but they are shifting when I put new day's data.So I need to shift back them to the correct location(date) everyday. Thanks in advance! -- KHAN |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
Automatically update charts for only the most current 12 months? | Charts and Charting in Excel | |||
Create charts that update automatically from data in rows | Charts and Charting in Excel | |||
Update Charts X-axis | Excel Discussion (Misc queries) | |||
Dates that automatically update ... | Excel Discussion (Misc queries) |