If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Radar Chart
I am making a Radar Chart that can change as the data changes in the source
cells. The problem occurs when some rows change and do not have data in them. I dont want these "blank" cells to be displayed as a blank points on the Radar chart but can't delete the rows as these may be required in the next data set. When the cells are blank they are hidden but the radar graph still includes the hidden and balnk cell. Could you offer any advise as to how to get the radar graph to ignore blank rows. Thanks in advance, Angus |
#2
|
|||
|
|||
Angus -
You need to use dynamic named ranges that resize themselves according to the number of filled rows. I have some examples and links to more examples he http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Angus Robinson wrote: I am making a Radar Chart that can change as the data changes in the source cells. The problem occurs when some rows change and do not have data in them. I dont want these "blank" cells to be displayed as a blank points on the Radar chart but can't delete the rows as these may be required in the next data set. When the cells are blank they are hidden but the radar graph still includes the hidden and balnk cell. Could you offer any advise as to how to get the radar graph to ignore blank rows. Thanks in advance, Angus |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Urgent Chart Questions | Brent E | General Discussion | 0 | May 9th, 2005 11:01 PM |
Selecting Charts in a Macro | Herman Merman | Charts and Charting | 1 | August 18th, 2004 12:25 AM |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |
Using Transparent Colors in a Radar Chart | Marc Davidson | Charts and Charting | 5 | January 22nd, 2004 07:06 PM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |