Hi, I know this is an excel forum, but the topic is somewhat relevant I'm hoping the user base here might have the right knowledge.
I'm putting bar charts in a MS Word document. For each chart an embedded excel worksheet pops up and I can go in and update the data for that chart. All is good. However, I'm doing a report that has 15 charts on a single page. I need to go in and right click each and every chart to open up each and every excel sheet to update the numbers. The charts are all similar (basically each chart is for a different project, and the page is an overview of all the projects). I would like to have a *single* excel sheet that would have all the data in a single table, so that I can open up just the one sheet and update everything instead of having to update multiple sheets. This way I can scan across the numbers at the same time and make sure everything is OK. Has anyone done that before? Thanks in advance for any suggestions! Anthony -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
