Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatically plotting one cell from newly completed sheets
Hi
I have a spreadsheet that records productivity figures on a daily basis, so each day has a separate work sheet. I'm trying to get a graph to plot a single cell from each sheet. Ideally I would want to get the graph to automatically plot the same cell from any new sheets created. For Example, if I create a new sheet for the next day it would automatically add that new figure to the graph. I'm not even sure this is possible, but your comments would really help! Thanks Oli |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically plotting one cell from newly completed sheets
Set up a single row, with labels above each cell, on the worksheet to contain the chart.
Each cell in the row would reference a single cell from each separate sheet. Create your chart using the two rows as the data source. -- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (Data Options add-in: insert rows/date picker/clean data/random stuff) "olichap" wrote in message ... Hi I have a spreadsheet that records productivity figures on a daily basis, so each day has a separate work sheet. I'm trying to get a graph to plot a single cell from each sheet. Ideally I would want to get the graph to automatically plot the same cell from any new sheets created. For Example, if I create a new sheet for the next day it would automatically add that new figure to the graph. I'm not even sure this is possible, but your comments would really help! Thanks Oli -- olichap |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's the easiest way to relink sheets to a newly copied master. | Excel Worksheet Functions | |||
Running macros in newly created sheets | Excel Programming | |||
Automatically fill one cell in any newly inserted row | Excel Discussion (Misc queries) | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
how do i get the name of a newly added sheet that i add with Sheets.Add in a vba macro in excel? | Excel Worksheet Functions |