Apply a macro only to highlighted cells

[newwithexcel]

I have data in columns that I want to create charts for. However, this data is dynamic and the number of cells where there is data varies. The rest of the cells that don't have numbers have 0s, however if I applied a macro to the whole column all of the zeros would show up in the resulting charts. How can I create a macro where I can highlight just the cells (the ones with non-zero numbers) that I want a chart to be generated for. Thanks for your help! Or is there a way to ignore zeros/blanks completely in the macro?


Example: here are two columns with data. I want to make a macro that creates a chart by just highlighting the actual numbers and ignoring the zeros. Thanks!


[TABLE="width: 96"]
<TBODY>[TR]
[TD="width: 64, bgcolor: transparent"]Mexico
[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]0.171896
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]USA
[/TD]
[TD="bgcolor: transparent, align: right"]0.132952
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Germany
[/TD]
[TD="bgcolor: transparent, align: right"]0.113626
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Colombia
[/TD]
[TD="bgcolor: transparent, align: right"]0.096198
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]UK
[/TD]
[TD="bgcolor: transparent, align: right"]0.085729
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]France
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[/TR]
</TBODY>[/TABLE]

[TABLE="width: 96"]
<TBODY>[TR]
[TD="width: 64, bgcolor: transparent"]Mexico
[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]0.171896
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]USA
[/TD]
[TD="bgcolor: transparent, align: right"]0.132952
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Germany
[/TD]
[TD="bgcolor: transparent, align: right"]0.113626
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Colombia
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]UK
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]France
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[venkat1926]

see DAVE HAWLEY'S suggestion in

Plot Values Above Zero On Line Chart