Excel Combine two columns into one series in the chart

[steinfeld]

I have looked High and low for a solution to this and I dont seem to be making any headway. I have a very large workbook. I graph many things in this workbook. I am trying to figure out if there is a way to combine two sets of values for the y values of a line chart. In other words column D and column H have the y values I want to combine in one series on the chart without adding another column to the sheet.

 

[SkipVought]

Hi,

I know of no way. If you don't want another column on that sheet, put the column sums on another sheet and be done with it.

Skip,

_[red][/red]