Thread: [SOLVED] How do I add the sums of a group of columns to a series in chart?

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?

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
_______


"Ron" <Ron@discussions.microsoft.com> wrote in message
news:C05A263F-464C-4B9E-94BC-188DB726DB4F@microsoft.com...
>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?