 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / July 2006Creating a chart from multiple worksheets
I'm trying to create a chart using the same cell reference in several worksheets. Does anyone know a quick way to do this? Do you want to make one chart from several references, from different sheets, OR do you want to make a chart in several worksheets (copying the chart) referring to the same cell references, but in different sheets? Henk > I'm trying to create a chart using the same cell reference in several > worksheets. Does anyone know a quick way to do this? > Do you want to make one chart from several references, from different sheets, > OR do you want to make a chart in several worksheets (copying the chart) [quoted text clipped - 3 lines] > > I'm trying to create a chart using the same cell reference in several > > worksheets. Does anyone know a quick way to do this? I'm looking to make on chart from several different worksheets using the same cell reference from each sheet. I was trying to find a shortcut (formula) I can enter into the chart wizard. I tryed selecting the cell reference and then holding the shift key to highlight the other worksheets (=!sheet1:sheet4!$B$3) but it gives me an error. Any ideas? > Do you want to make one chart from several references, from different sheets, > OR do you want to make a chart in several worksheets (copying the chart) [quoted text clipped - 3 lines] > > I'm trying to create a chart using the same cell reference in several > > worksheets. Does anyone know a quick way to do this? Read the link I posted. You probably will have to construct a helper range on another sheet to hold the data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > I'm looking to make on chart from several different worksheets using the > same [quoted text clipped - 14 lines] >> > I'm trying to create a chart using the same cell reference in several >> > worksheets. Does anyone know a quick way to do this? http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > I'm trying to create a chart using the same cell reference in several > worksheets. Does anyone know a quick way to do this? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.