Build a graph that reads data from a few worksheets

  • Thread starter Thread starter rixanna
  • Start date Start date
R

rixanna

How to build a graph that reads data from a few worksheets?
As an example;
In worksheet 01, we have
A - 12
B - 45
Percentage - 72

In worksheet 02, we have
A - 53
B - 22
Percentage - 51

I wanted to build a graph in worksheet GRAPH that reads these data.

Horizontal (X) - Day (01,02)
Vertical (Y) - Amount

This means that for every point (01,02...) in X will have 3 bars
representing A, B and Percentage.
Any ideas?
 
rixanna,

You need to build a table that links to the cells of interest from the various sheets.

HTH,
Bernie
MS Excel MVP
 
Back
Top