Monthly Charts

[Chris Hagwood]

I'm creating a chart of activity each month that contains a 12-month
history. It's usually a line chart of some activity per month for the
last 12 months.

What I want to do is delete the first month's cell, and shift cells
left. Then add the new month to the end. When I do this, the chart
does not include the new month's data.

How do I format the source data for the chart to be a particular row
of 12 cells, no matter what happens to those original cells. I don't
want it to follow the cells to the left when I delete them!

Thanks!

 

[Victor Delta]

I'm creating a chart of activity each month that contains a 12-month
history. It's usually a line chart of some activity per month for the
last 12 months.

What I want to do is delete the first month's cell, and shift cells
left. Then add the new month to the end. When I do this, the chart
does not include the new month's data.

How do I format the source data for the chart to be a particular row
of 12 cells, no matter what happens to those original cells. I don't
want it to follow the cells to the left when I delete them!

You need a dynamic chart - try googling this.

For example http://peltiertech.com/Excel/Charts/DynamicLast12.html

V

 

[CellShocked]

I'm creating a chart of activity each month that contains a 12-month
history. It's usually a line chart of some activity per month for the
last 12 months.

What I want to do is delete the first month's cell, and shift cells
left. Then add the new month to the end. When I do this, the chart
does not include the new month's data.

How do I format the source data for the chart to be a particular row
of 12 cells, no matter what happens to those original cells. I don't
want it to follow the cells to the left when I delete them!

Thanks!

Don't delete them then. REPLACE the data.

You can erase the previous by using "clear contents" after highlighting
the data cells.

 

[CellShocked]

Don't delete them then. REPLACE the data.

You can erase the previous by using "clear contents" after highlighting
the data cells.

Oh, you can also insert two columns just before the last column in your
current data, and delete all to the left of those and that last column as
well, and as along as you paste your new data inside those two blank
columns you just inserted, you will retain the capture of your graph.

You can then delete each blank column to correct the data set.

 

[Chris Hagwood]

  Don't delete them then.  REPLACE the data.

  You can erase the previous by using "clear contents" after highlighting
the data cells.

I think this is what I'm after. I have the data, plus a calculated
mean, mean+standard deviation, and m-sd plotted, so I don't really
want to keep growing the data set beyond what I have, I just want to
keep track and calculate based on the current 12 month set.

I guess I would need to copy 12-months worth of values for the data,
then 'clear contents' for the 12 months, then paste in the new
values. I'll try that.