|
Names and Series in Charts
Hi all,
Here's what I have so far - first worksheet 'Data Set' where data for numbers of events of different categories per fortnightly period is entered, subsequent worksheets extract the data per individual category and produce a process control chart which auto-updates showing the last 26 periods only, based on date in a row along the top.
Each chart per spreadsheet shows the actual no. of events, mean, upper control limit and lower control limit using OFFSET from the date row (as in Jon Peltier's dynamic chart example). These come from ranges (imaginatively) titled 'Chart_Recorded', 'Chart Mean', 'Chart UCL' and 'Chart LCL'.
This works fine on the first chart but on the subsequent sheets the charts always seem to default to the first Series and 'file name'!Chart_Recorded etc.
Does anyone know if it's possible to use the same named series but force Excel to look at the specific/relevant worksheet?
Hope this makes sense!
Robert
|
01-27-2005, 11:43 AM
New topics in Excel Charting
Linear Mode
