Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't figure out how to hold chart references firm when inserting data
I'm embarrassed to ask, but I can't figure it out :) I have 5 columns that
are charted and on a daily/weekly basis I have new data to enter with each new day. I want the chart to reflect the data for the last 60 days. My problem is when I insert new cells and push the data down, the refernces in the chart move as well, so its not showing the last 60 days. I'd like the chart to reflect sliding data (I think thats the term). HELP :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't figure out how to hold chart references firm when insertingdata
Use dynamic names as the chart data source. Here's a simple explanation
of dynamic charts with several links: Dynamic Charts | PTS Blog http://peltiertech.com/WordPress/dynamic-charts/ In your case, you need to define ranges which use the unchanging header row as the reference. For example, define this name: Name: TheDates RefersTo: =OFFSET($A$1,1,0,60,1) Name: TheValues1 RefersTo: =OFFSET(TheDates,0,1) Assuming the headers are in row 1 and your dates in column A. Adjust your chart so series 1 uses TheDates and TheValues1 instead of hard coded cell addresses as its source data. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Live Long & Prosper wrote: I'm embarrassed to ask, but I can't figure it out :) I have 5 columns that are charted and on a daily/weekly basis I have new data to enter with each new day. I want the chart to reflect the data for the last 60 days. My problem is when I insert new cells and push the data down, the refernces in the chart move as well, so its not showing the last 60 days. I'd like the chart to reflect sliding data (I think thats the term). HELP :) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't figure out how to hold chart references firm when inserting data
Simple when ya know how AND it makes sense.
THANKS Jon! {more coffee is needed :)} Jon Peltier wrote in : Use dynamic names as the chart data source. Here's a simple explanation of dynamic charts with several links: Dynamic Charts | PTS Blog http://peltiertech.com/WordPress/dynamic-charts/ In your case, you need to define ranges which use the unchanging header row as the reference. For example, define this name: Name: TheDates RefersTo: =OFFSET($A$1,1,0,60,1) Name: TheValues1 RefersTo: =OFFSET(TheDates,0,1) Assuming the headers are in row 1 and your dates in column A. Adjust your chart so series 1 uses TheDates and TheValues1 instead of hard coded cell addresses as its source data. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Live Long & Prosper wrote: I'm embarrassed to ask, but I can't figure it out :) I have 5 columns that are charted and on a daily/weekly basis I have new data to enter with each new day. I want the chart to reflect the data for the last 60 days. My problem is when I insert new cells and push the data down, the refernces in the chart move as well, so its not showing the last 60 days. I'd like the chart to reflect sliding data (I think thats the term). HELP :) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't figure out how to hold chart references firm when insertin
I have a similar graph showing rolling 12 months. Insert a row in between
the last row and the 2nd to last row. Copy the last row into the NEW second to last row, then put your new data into the last row. Hide the row(s) you no longer want on the graph. "Live Long & Prosper" wrote: I'm embarrassed to ask, but I can't figure it out :) I have 5 columns that are charted and on a daily/weekly basis I have new data to enter with each new day. I want the chart to reflect the data for the last 60 days. My problem is when I insert new cells and push the data down, the refernces in the chart move as well, so its not showing the last 60 days. I'd like the chart to reflect sliding data (I think thats the term). HELP :) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart won't hold formatting | Charts and Charting in Excel | |||
locate data from a chart by inserting data into a cell | Excel Worksheet Functions | |||
Inserting a chart of data into Word | Excel Discussion (Misc queries) | |||
How can I paste a formula that references a chart of data | Excel Worksheet Functions | |||
Inserting Data set into chart | Charts and Charting in Excel |