Build a graph that reads data from a few worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rixanna - 04 Jan 2007 00:34 GMT

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?

Reply to this Message

Bernie Deitrick - 04 Jan 2007 15:19 GMT

rixanna,

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

HTH,
Bernie
MS Excel MVP

> How to build a graph that reads data from a few worksheets?
> As an example;
[quoted text clipped - 16 lines]
> representing A, B and Percentage.
> Any ideas?

Reply to this Message