Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Articles > Chart an Equation > Create the Chart
Deze pagina in het Nederlands

Charting a mathematical equation using Excel and defined names

Create the Chart

 Because we cannot start creating a chart without data, simply add some data to a couple of cells:

and click the chart wizard button. Make sure to select the "XY (scatter)" chart type and hit Finish.

Now define two names local to the worksheet the chart is on:

Name Refers To
Sheet1!x $A$12:$A$15
Sheet1!y $B$12:$B$15

Now we need to use these two defined names in the chart's SERIES formula (click the line in the chart and then click the formula bar), currently looking like this:

(Note this shows the SERIES formula as I see it, with the semicolon as list separator.)

Edit this formula so it looks like this:

=SERIES(Sheet1!$B$8,Sheet1!x,Sheet1!y,1)

Cell B8 will contain the chart's title, so we'll put this little formula in B8:

="Charting: " & Sheet1!$B$1