Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
write graph series using formulas
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
write graph series using formulas
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/ChartsH...esFormula.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...00906ACNJ.html _______ "Ahmed Younis" <Ahmed wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph data series formulas: How to global-change all sheet reference to formula | Excel Discussion (Misc queries) | |||
How do I plot multiple series on one graph? - test-graph.xls (0/1) | Charts and Charting in Excel | |||
How do I plot multiple series on one graph? - test-graph.xls (1/1) | Charts and Charting in Excel | |||
Graph Series Questions | Charts and Charting in Excel | |||
series graph -- one series being added to another series | Charts and Charting in Excel |