write graph series using formulas

A

Ahmed Younis

Can we write or edit graph's series instead of selecting the required cells
by setting a formula that reflects the required cells to be selected?
 
J

Jon Peltier

When you select a series in a chart, there is a formula in the formula bar:

=SERIES(etc.)

This formula has four parameters: Series Name, X values, Y values, plot
order. If it's a bubble chart it has a fifth parameter for bubble size.

You can edit these formulas right in the formula bar, you can copy a
formula, select the plot area, and paste the formula into the formula bar to
add it to the same or a different chart. And you can simply select the plot
area and start writing your own series formula.

Here's an article about the chart series formula:
http://peltiertech.com/Excel/ChartsHowTo/ChartSeriesFormula.html

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xy scatter graph 0
Can I use 'names' in defining a series in a graph 1
Changing graph axes using named range 2
line series order Excel 2007 3
Graphs using indirect addressing 3
extend graph axis automatically in excel 1
Series fill only copying and fill series greyed out 1
Remove the blank colum in the graph from merged cells 1

Top