Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
My dynamic chart get empty when I delette all content, then fill with new
one. It should auto adjust. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
I'd check out each of your dynamic ranges to see what's selected. CTRL G
and type in the range name. If you get an error, there's your problem. -- HTH, Barb Reinhardt "Feejo" wrote: My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
Is really dynamic chart should show in ctrl+G.
"Barb Reinhardt" wrote: I'd check out each of your dynamic ranges to see what's selected. CTRL G and type in the range name. If you get an error, there's your problem. -- HTH, Barb Reinhardt "Feejo" wrote: My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
I'm assuming you have named ranges for the series. What are they? Type
Control G and the range name for each series to see where that takes you. You also should take a look at the series definitions. Depending on how the series is defined, it may not be the same if you delete data. -- HTH, Barb Reinhardt "Feejo" wrote: Is really dynamic chart should show in ctrl+G. "Barb Reinhardt" wrote: I'd check out each of your dynamic ranges to see what's selected. CTRL G and type in the range name. If you get an error, there's your problem. -- HTH, Barb Reinhardt "Feejo" wrote: My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
If your Names are defined using OFFSET, with the first record of the data as
the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
Ok I have 2 series, and 2 axis. Let's work to make one axis work.
That particular row is not deleted, but a calcules and they are put to 0 all of them, then populated again. That is when they disapear. And I only delette the content on the row not the row itselve. Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1) "Jon Peltier" wrote: If your Names are defined using OFFSET, with the first record of the data as the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
I'd be willing to bet that the result for this calculation is zero.
=COUNT(T!$BJ$22:$BJ$3019) Can you check that? -- HTH, Barb Reinhardt "Feejo" wrote: Ok I have 2 series, and 2 axis. Let's work to make one axis work. That particular row is not deleted, but a calcules and they are put to 0 all of them, then populated again. That is when they disapear. And I only delette the content on the row not the row itselve. Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1) "Jon Peltier" wrote: If your Names are defined using OFFSET, with the first record of the data as the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
Where do the new values come from? If they are imported from an external
source, you need to make sure that the new values are numerical, and not text that appears to be numerical. Also, after repopulating the range, open the Define Names dialog, select the name, and click in the Refers To formula box. Is the expected range highlighted in the worksheet? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... Ok I have 2 series, and 2 axis. Let's work to make one axis work. That particular row is not deleted, but a calcules and they are put to 0 all of them, then populated again. That is when they disapear. And I only delette the content on the row not the row itselve. Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1) "Jon Peltier" wrote: If your Names are defined using OFFSET, with the first record of the data as the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
One simple way to address this is to use:
=OFFSET('T'!$BJ$21;1;0;MAX(1;COUNT('T'!$BJ$22:$BJ$ 3019));1) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Barb Reinhardt" wrote in message ... I'd be willing to bet that the result for this calculation is zero. =COUNT(T!$BJ$22:$BJ$3019) Can you check that? -- HTH, Barb Reinhardt "Feejo" wrote: Ok I have 2 series, and 2 axis. Let's work to make one axis work. That particular row is not deleted, but a calcules and they are put to 0 all of them, then populated again. That is when they disapear. And I only delette the content on the row not the row itselve. Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1) "Jon Peltier" wrote: If your Names are defined using OFFSET, with the first record of the data as the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
0 right.
"Barb Reinhardt" wrote: I'd be willing to bet that the result for this calculation is zero. =COUNT(T!$BJ$22:$BJ$3019) Can you check that? -- HTH, Barb Reinhardt "Feejo" wrote: Ok I have 2 series, and 2 axis. Let's work to make one axis work. That particular row is not deleted, but a calcules and they are put to 0 all of them, then populated again. That is when they disapear. And I only delette the content on the row not the row itselve. Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1) "Jon Peltier" wrote: If your Names are defined using OFFSET, with the first record of the data as the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
When I click Name manager, I look at the selection from the name and IT IS
the right selection, that what is strange to me. "Jon Peltier" wrote: Where do the new values come from? If they are imported from an external source, you need to make sure that the new values are numerical, and not text that appears to be numerical. Also, after repopulating the range, open the Define Names dialog, select the name, and click in the Refers To formula box. Is the expected range highlighted in the worksheet? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... Ok I have 2 series, and 2 axis. Let's work to make one axis work. That particular row is not deleted, but a calcules and they are put to 0 all of them, then populated again. That is when they disapear. And I only delette the content on the row not the row itselve. Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1) "Jon Peltier" wrote: If your Names are defined using OFFSET, with the first record of the data as the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
Oh this one work well, but why that was working well in 2003 and and I have
to change that in 2007? "Jon Peltier" wrote: One simple way to address this is to use: =OFFSET('T'!$BJ$21;1;0;MAX(1;COUNT('T'!$BJ$22:$BJ$ 3019));1) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Barb Reinhardt" wrote in message ... I'd be willing to bet that the result for this calculation is zero. =COUNT(T!$BJ$22:$BJ$3019) Can you check that? -- HTH, Barb Reinhardt "Feejo" wrote: Ok I have 2 series, and 2 axis. Let's work to make one axis work. That particular row is not deleted, but a calcules and they are put to 0 all of them, then populated again. That is when they disapear. And I only delette the content on the row not the row itselve. Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1) "Jon Peltier" wrote: If your Names are defined using OFFSET, with the first record of the data as the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
Perhaps 2003 ignored the error when you tried to plot a range containing
zero cells. 2007 seems to be less forgiving when working with Names and charts. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... Oh this one work well, but why that was working well in 2003 and and I have to change that in 2007? "Jon Peltier" wrote: One simple way to address this is to use: =OFFSET('T'!$BJ$21;1;0;MAX(1;COUNT('T'!$BJ$22:$BJ$ 3019));1) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Barb Reinhardt" wrote in message ... I'd be willing to bet that the result for this calculation is zero. =COUNT(T!$BJ$22:$BJ$3019) Can you check that? -- HTH, Barb Reinhardt "Feejo" wrote: Ok I have 2 series, and 2 axis. Let's work to make one axis work. That particular row is not deleted, but a calcules and they are put to 0 all of them, then populated again. That is when they disapear. And I only delette the content on the row not the row itselve. Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1) "Jon Peltier" wrote: If your Names are defined using OFFSET, with the first record of the data as the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
Calculation is set to automatic, not manual?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... When I click Name manager, I look at the selection from the name and IT IS the right selection, that what is strange to me. "Jon Peltier" wrote: Where do the new values come from? If they are imported from an external source, you need to make sure that the new values are numerical, and not text that appears to be numerical. Also, after repopulating the range, open the Define Names dialog, select the name, and click in the Refers To formula box. Is the expected range highlighted in the worksheet? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... Ok I have 2 series, and 2 axis. Let's work to make one axis work. That particular row is not deleted, but a calcules and they are put to 0 all of them, then populated again. That is when they disapear. And I only delette the content on the row not the row itselve. Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1) "Jon Peltier" wrote: If your Names are defined using OFFSET, with the first record of the data as the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
Automatic, but my sheet have alot of error. I will try to correct them all.
Maby there is a ignore all error? "Jon Peltier" wrote: Calculation is set to automatic, not manual? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... When I click Name manager, I look at the selection from the name and IT IS the right selection, that what is strange to me. "Jon Peltier" wrote: Where do the new values come from? If they are imported from an external source, you need to make sure that the new values are numerical, and not text that appears to be numerical. Also, after repopulating the range, open the Define Names dialog, select the name, and click in the Refers To formula box. Is the expected range highlighted in the worksheet? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... Ok I have 2 series, and 2 axis. Let's work to make one axis work. That particular row is not deleted, but a calcules and they are put to 0 all of them, then populated again. That is when they disapear. And I only delette the content on the row not the row itselve. Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1) "Jon Peltier" wrote: If your Names are defined using OFFSET, with the first record of the data as the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
No, you have to adjust the formulas so they ignore them. For example:
=IF(B1<0,A1/B1,0) =IF(ISNA(MATCH(A1,B1:B10)),"",MATCH(A1,B1:B10)) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... Automatic, but my sheet have alot of error. I will try to correct them all. Maby there is a ignore all error? "Jon Peltier" wrote: Calculation is set to automatic, not manual? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... When I click Name manager, I look at the selection from the name and IT IS the right selection, that what is strange to me. "Jon Peltier" wrote: Where do the new values come from? If they are imported from an external source, you need to make sure that the new values are numerical, and not text that appears to be numerical. Also, after repopulating the range, open the Define Names dialog, select the name, and click in the Refers To formula box. Is the expected range highlighted in the worksheet? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... Ok I have 2 series, and 2 axis. Let's work to make one axis work. That particular row is not deleted, but a calcules and they are put to 0 all of them, then populated again. That is when they disapear. And I only delette the content on the row not the row itselve. Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1) "Jon Peltier" wrote: If your Names are defined using OFFSET, with the first record of the data as the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
#17
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart empty with new data in the dynamic range chart.
I start over with the original cause nothing was working often.
I installed the convertions patch of 2003 to 2007, sorry it is in french. Problème de compatibilité avec les formats de fichier Word, Excel et PowerPoint ? http://www.microsoft.com/downloads/d...displaylang=fr And it worked right away. "Jon Peltier" wrote: No, you have to adjust the formulas so they ignore them. For example: =IF(B1<0,A1/B1,0) =IF(ISNA(MATCH(A1,B1:B10)),"",MATCH(A1,B1:B10)) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... Automatic, but my sheet have alot of error. I will try to correct them all. Maby there is a ignore all error? "Jon Peltier" wrote: Calculation is set to automatic, not manual? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... When I click Name manager, I look at the selection from the name and IT IS the right selection, that what is strange to me. "Jon Peltier" wrote: Where do the new values come from? If they are imported from an external source, you need to make sure that the new values are numerical, and not text that appears to be numerical. Also, after repopulating the range, open the Define Names dialog, select the name, and click in the Refers To formula box. Is the expected range highlighted in the worksheet? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... Ok I have 2 series, and 2 axis. Let's work to make one axis work. That particular row is not deleted, but a calcules and they are put to 0 all of them, then populated again. That is when they disapear. And I only delette the content on the row not the row itselve. Ex: =OFFSET('T'!$BJ$21;1;0;COUNT('T'!$BJ$22:$BJ$3019); 1) "Jon Peltier" wrote: If your Names are defined using OFFSET, with the first record of the data as the reference range (first argument of OFFSET), and you delete the first row, then there is no longer a valid reference range (you've deleted it). Instead of deleting the entire rows, select them and press Delete or use Edit menu Clear All or Clear Contents. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... My dynamic chart get empty when I delette all content, then fill with new one. It should auto adjust. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic chart on user selected data range in Excel 2007 | Charts and Charting in Excel | |||
Can't chart dynamic named range?? | Charts and Charting in Excel | |||
Dynamic range in chart | Charts and Charting in Excel | |||
Dynamic column chart - auto sort on data range | Charts and Charting in Excel | |||
Dynamic Range Chart ??? | Charts and Charting in Excel |