We help IT Professionals succeed at work.

Adding two columns - Excel Chart

Seamus2626
Seamus2626 asked
on
Hi,

I currently have a Bar Chart and in the Source Data i have the following series

Values  =Data!$C$551:$O$551
I want to sum up two rows, so i was trying to enter

=Data!$C$551:$O$551+Data!$C$552:$O$552

Im getting an error message for this. How can i add to columns together using this function, ive attached a screenshot of my source data

Thanks
Seamus





Doc4.doc
Comment
Watch Question

You can't perform an operation on data selected for a chart.  Instead, put the following formulas in cells P551 and P552, then use those two cells for your chart:

=SUM(C551:O551)
=SUM(C552:O552)

Values =Data!P551:P552  (The $ isn't necessary for what you're trying to accomplish)

Author

Commented:
Thanks Mark!