Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adjusting chart info
I'm wondering if there is a way to adjust the source data range by referring
to a cell in a spreadsheet? For example, I have multiple departments with 2 years of data but I only want to look at one department at a time on the graph. My data is lined up with the department in column A with 24 columns of months following in B thru Y. Right now, I have the source data set up with Series One as Column B thru M and Series 2 as N thru Y for row 2 which is dept 1. I would like to have a cell that references which department I want to look at so that when I change the department number in that cell, the source data would change to the row that department is in. The series column letters would stay constant but the row would change dependent on a cell or formula linked to the department row. Is this possible? Thank you for your assistance! -- Constance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet cell info to chart | Charts and Charting in Excel | |||
Automatically adjusting chart reference | Excel Worksheet Functions | |||
Adding Info to Chart | Charts and Charting in Excel | |||
Chart: range info from seriescollection? | Charts and Charting in Excel | |||
plotting info into chart format | Charts and Charting in Excel |