Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Range Mess
I am using the following raw data for my line chart. In this case I have 5
charts on each sheet tab. One for Bolts, one for Nuts and so on.. I also have 25 sheet tabs for each customer. The way it's set up now is that the line chart only covers the data range of year 2002, 2003 & 2004. When I want to add each year I have to go into 5 charts on each tab and 25 tabs for each customer to select that data range. Initially, It should have been set up to highlight the data range up an until year 2008 so I could just plug in the numbers for each year and that data would populate the chart. Should I just go into each chart and each tab and highlight the data until 2008 or is there an easier way to do this so I don't have to do all that highlighting? Thank you, Karen 2002 2003 2004 2005 2006 2007 2008 Bolts 2145 2500 3245 Nuts 5214 5628 5487 Screws 526 650 698 Elbows 457 487 412 Nails 1248 1348 1578 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
data range | Excel Discussion (Misc queries) | |||
Formula Changes when data entered in referenced range | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |