| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change activex control properties from a macro | Excel Discussion (Misc queries) | |||
| API for MS Chart Control | Charts and Charting in Excel | |||
| how do I protect a worksheet and still use a checkbox control | Excel Worksheet Functions | |||
| How to move location of chart within a worksheet? | Excel Discussion (Misc queries) | |||
| color gradient in a worksheet (not a chart), Is it Possible? | Excel Worksheet Functions | |||
Hybrid Mode
