close

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

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

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 -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______quot;Marko Pintericquot; gt; wrote in message
news
gt;
gt; Hello experts!
gt;
gt; Is it possible to control the chart properties from the worksheet?
gt;
gt; I know it is possible to control legend texts (series names).
gt;
gt; I am especially interested in controlling the ranges of series. How to
gt; control the title and other texts on the chart would be also useful.
gt;
gt; Best regards,
gt;
gt; Marko

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()