 |
 | 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 / October 2006Multiple charts
I have 5 identical worksheets with different data contained in the cells. Instead of making 5 charts individually is the a way of selecting all the worksheets and making a chart on one of the worksheets but then it automatically makes the identical charts in the other selected worksheets. This would save me a lot of time.... or is this only possible by writing a macro and if it is.... i dont know how to... thank you in advance Is it possible to make the chart on the first worksheet, copy that worksheet and then paste the data into the copy? Then repeat? Yes well i know how to do that i was just thinking that there might be a way of just doing one chart for all worksheets so that i would save time. thanks for the help though > Is it possible to make the chart on the first worksheet, copy that > worksheet and then paste the data into the copy? Then repeat? why not save the overhead and DO have just one with variable ranges controlled by a double click macro on the range list.  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Yes well i know how to do that i was just thinking that there might be a > way [quoted text clipped - 4 lines] >> Is it possible to make the chart on the first worksheet, copy that >> worksheet and then paste the data into the copy? Then repeat? |
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
|
©2009 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.