View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stan Stan is offline
external usenet poster
 
Posts: 150
Default Charting in Excel

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