Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts that get Bigger/Smaller
I posted earlier about creating a dynamic chart, and I've found lots
of links to tutorials that show you how to move a range - like the 6 recent months, or charts that grow as you add data. But what about a chart that can get smaller, in theory, this should work the same, but I am having trouble implementing this. Basically, a user selects a option from a drop down. Based on their choice, the data range can be populated 3 different ways, with say 5, 10, or 20 rows of data. With the extra rows being populated by a formula that leaves behind a "". The problem that I cannot get past, is that the Chart always displays 20 rows - with extra blank labels and extra zero values. Thoughts? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts that get Bigger/Smaller
What kind of chart? If it's a line or XY chart, use NA() instead of "" in
your formulas. It leaves an ugly #N/A error in the cells, but the error will not plot in the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ups.com... I posted earlier about creating a dynamic chart, and I've found lots of links to tutorials that show you how to move a range - like the 6 recent months, or charts that grow as you add data. But what about a chart that can get smaller, in theory, this should work the same, but I am having trouble implementing this. Basically, a user selects a option from a drop down. Based on their choice, the data range can be populated 3 different ways, with say 5, 10, or 20 rows of data. With the extra rows being populated by a formula that leaves behind a "". The problem that I cannot get past, is that the Chart always displays 20 rows - with extra blank labels and extra zero values. Thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts that get Bigger/Smaller | Excel Discussion (Misc queries) | |||
Font size smaller and bigger in a formula | Excel Worksheet Functions | |||
changing color of values bigger or smaller than target | New Users to Excel | |||
Excel 2000 (9.0.6926 SP3) spreadsheet getting bigger & bigger .... | Excel Discussion (Misc queries) | |||
How to find value that is bigger or smaller than 2SD? | Excel Discussion (Misc queries) |