series name
I have a chart setup that refers to sheet w/ data. I would like to enter the
name of the sheet (in a cell) that would update the sheet name in the chart series/data range so that my chart can view multiple data sets on different sheets. Is this possible and how? |
series name
This page has a couple approaches which may be informative:
http://peltiertech.com/Excel/ChartsH...iffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Andy" wrote in message ... I have a chart setup that refers to sheet w/ data. I would like to enter the name of the sheet (in a cell) that would update the sheet name in the chart series/data range so that my chart can view multiple data sets on different sheets. Is this possible and how? |
All times are GMT +1. The time now is 01:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com