Microsoft Excel Macros

[benchmarker]

Hey guys, I'm Jenna. I'm a noob when it comes to Macros and found a workaround to taking out the 0% and labels to my pie chart. Although that might sound like an accomplishment, the bigger problem lies on how to take 0/0.0 on my column chart.
I have a weekly report on our statistics class and I want to automatically delete them without going through the whole bunch of data. If you want to see my sample/raw excel file, I can post it here.

Please help me, I'm just sad I don't know how to remedy this.

Thanks guys!

p.s. I'm using MS Excel 2007

 

[Trotter]

Check this article and see if it helps:

Three ways to hide zero values in an Excel sheet | TechRepublic

 

[benchmarker]

Thanks for posting this info. I've read about this and used it on my revision but I cannot get my problem fully resolved. I'm working on a column chart and not just ordinary cells on Excel, whereby the steps you provided might be beneficial if it's the cells we're trying to format. I don't wan't to delete the zeros on my raw data sheet, I just want to delete the zero fields on my chart(column). Is getting the "0/0.0" field on my column chart even possible with VBA coding?


Thanks again for replying Trotter.