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

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!

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