How do I add the sums of a group of columns to a series in chart?

[Guest]

I have a series of monthly totals I am plotting on a chart using:

Sales!$B$1:$M$1

to send the data to the chart. I want to lump some of these into a category
called "Others". How do I send multiple sums to the same series?

 

[Jon Peltier]

Combine them into a range in the worksheet (using SUM), then plot this range
as the "Other" column.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______