Question by  Cjc (299)

How do you merge your excel bar chart from two worksheets into the same workbook?

I need help with excel.


Answer by  benji (165)

Open both the worksheets. On the tools menu you have a way of merging two worksheets as long as the variables are similar. However I tried this and messed up my whole data and graphs. Hope you have much better luck than me. BTW, I'm a complete novice!

Reply by theblip (295):
I somehow don't like the layout and the way the menu is placed in the new MS Excel - loved the office 97 version as it was much simpler.  add a comment

Answer by  Silvio (61)

When you select the source for the bar chart, you must go to the second Worksheet, and select the proper cell range. You can include two or more sheets in an unique bar chart


Answer by  enlightened (206)

If the variables in both these graphs are the same and only the values are different why don't you simply add the data into one excel worksheet and generate a new bar chart with the combined data. This is easy for simple data only.


Answer by  gigo (1706)

The best thing to do that is to use vba. With two excel root objects you can load the two documents. After that you can access the worksheets and read the data. If you have that, you can add new worksheets to a third document with the data.


Answer by  ArunVivek (143)

1. Open WorkBookX1 - Open MS Excel. Select folder location - saveas WorkBookX1. 2. Go to Tools - Share Workbook - Allow changes - click OK. 3. Add More Data - Open WorkBookX2 - Open MS Excel. Select folder location - saveas WorkBookX2. 4. Save - Click Tools - Compare and Merge Workbooks & select the workbooks it will be merged

Reply by sleepyjey (248):
makes sense - but why do you need to open the WorkBook (X1 and X2) and then save them again?  add a comment
You have 50 words left!