Charting in Excel

[stan]

Hello I was following a tutorial that demonstrated how to create dynamic
charts in excel. I came to this step and was confused as to hwo I create a
chart with a formula. Can someone please help me out with this?

Create a chart with the formula:
=SERIES('One column'!WhichYear,'One column'!XValues,'One column'!YValues,1)

Thanks,
Stan

 

[Jon Peltier]

Presumably you have ranges defined on the worksheet 'One Column' that have
the names WhichYear, XValues, and YValues. Create a chart with non-dynamic
ranges, so the series formula looks something like:

=SERIES('One column'!$B$1,'One column'!$A$2:$A$11,'One column'!$B$2:$B$11,1)

then edit this formula to match the one you've posted.

- Jon