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

[soconfused]

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.

 

[David Biddulph]

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.

 

[soconfused]

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

 

[John Mansfield]

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/non_contiguous_named_ranges_as_chart_sources/

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

--
John Mansfield
http://cellmatrix.net