How to control chart properties from worksheet
 

Hello experts!

Is it possible to control the chart properties from the worksheet?

I know it is possible to control legend texts (series names).

I am especially interested in controlling the ranges of series. How to
control the title and other texts on the chart would be also useful.

Best regards,

Marko

How to control chart properties from worksheet
 

Marko -

You can control the length of the series by creating dynamic ranges and
using these as the data range for each series. See the examples and links
he

http://peltiertech.com/Excel/Charts/Dynamics.html

You can link a chart text element to a worksheet cell easily. Select the
element (chart title, axis title, individual data label, text box), type =,
then click on the cell and press Enter.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______


"Marko Pinteric" wrote in message
...

Hello experts!

Is it possible to control the chart properties from the worksheet?

I know it is possible to control legend texts (series names).

I am especially interested in controlling the ranges of series. How to
control the title and other texts on the chart would be also useful.

Best regards,

Marko