Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Easy dynamic chart.
Creating a dynamic chart is difficult, there should be a dynamic chart wizard
that will create it with you. Also if my serie value is a name range, it would be nice to just right the Name range directly not with the complex formula. ='xyz.xlsx'!name range but just name range. xyz and name range is a fictive value. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.charting |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Easy dynamic chart.
A wizard would sure be convenient, but I wouldn't count on seeing it in
Excel any time soon. If your dynamic range only needs to expand and contract as data is added or removed from a range, you can convert the range to a List (Excel 2003: Data menu, List... or Excel 2007, not sure the tab, but convert to Table). As the List/Table resizes, any formulas, including chart series formulas, automatically change the reference to all of the rows in the List/Table. Otherwise, you need to specify the worksheet or workbook containing the Name, otherwise the chart will not be assured of finding it correctly. You have to use the worksheet name when assigning a regular range address, and doing so for a Name is really no different. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... Creating a dynamic chart is difficult, there should be a dynamic chart wizard that will create it with you. Also if my serie value is a name range, it would be nice to just right the Name range directly not with the complex formula. ='xyz.xlsx'!name range but just name range. xyz and name range is a fictive value. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.charting |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic chart -easy question that has me stuck | Excel Discussion (Misc queries) | |||
Dynamic Chart | Excel Discussion (Misc queries) | |||
Dynamic chart | Charts and Charting in Excel | |||
dynamic end on chart | Charts and Charting in Excel | |||
Dynamic Chart/How to | Charts and Charting in Excel |