How do I add different cells to have one bar chart?
 

I have two different worksheets that I need to chart. I only want specific
cells from each sheet to go into a bar chart. I can't seem to make just one
continuous bar.

Thanks in advance.
--
DMM

How do I add different cells to have one bar chart?
 

The easiest way is to pull all the data you want for one series into one
continuous range on one worksheet. You can do this by linking from wherever
your source data is. Then create your graph from this range.
--
David Biddulph

"soconfused" wrote in message
...
I have two different worksheets that I need to chart. I only want specific
cells from each sheet to go into a bar chart. I can't seem to make just
one
continuous bar.

Thanks in advance.
--
DMM

How do I add different cells to have one bar chart?
 

I wanted to do that, but my boss doesn't want it done that way. Is there a
different way of doing it?
--
DMM


"David Biddulph" wrote:

The easiest way is to pull all the data you want for one series into one
continuous range on one worksheet. You can do this by linking from wherever
your source data is. Then create your graph from this range.
--
David Biddulph

"soconfused" wrote in message
...
I have two different worksheets that I need to chart. I only want specific
cells from each sheet to go into a bar chart. I can't seem to make just
one
continuous bar.

Thanks in advance.
--
DMM

How do I add different cells to have one bar chart?
 

Yes, you can separate you source data with a comma - for example:

=Sheet1!$B$2:$C$4,Sheet1!$F$2:$G$4

This example uses named ranges to add noncontiguous ranges to a chart:

http://www.cellmatrix.net/index.php/...chart_sources/

For more information, look up "noncontiguous chart ranges" or something
similar.

--
John Mansfield
http://cellmatrix.net





"soconfused" wrote:

I wanted to do that, but my boss doesn't want it done that way. Is there a
different way of doing it?
--
DMM


"David Biddulph" wrote:

The easiest way is to pull all the data you want for one series into one
continuous range on one worksheet. You can do this by linking from wherever
your source data is. Then create your graph from this range.
--
David Biddulph

"soconfused" wrote in message
...
I have two different worksheets that I need to chart. I only want specific
cells from each sheet to go into a bar chart. I can't seem to make just
one
continuous bar.

Thanks in advance.
--
DMM