Hi Guys!
I am new to this forum and no great shakes at Excel, but I have a problem that I hope that you can help me with. My actual data is more sophisticated, but I have simplified it here for the purposes of clarity.
I have a simple two column spread sheet. Column 1 shows the Names, Columns 2 shows the number of hits:
Fred 1
Sam 23
Betty 7
June 0
Bill 15
Rich 0
I want to show this in a Bar chart but only want to display the names and hits for those that have a hit rate of more than Zero, so totally ignore June and Rich.
Cheers!!
ian
I am new to this forum and no great shakes at Excel, but I have a problem that I hope that you can help me with. My actual data is more sophisticated, but I have simplified it here for the purposes of clarity.
I have a simple two column spread sheet. Column 1 shows the Names, Columns 2 shows the number of hits:
Fred 1
Sam 23
Betty 7
June 0
Bill 15
Rich 0
I want to show this in a Bar chart but only want to display the names and hits for those that have a hit rate of more than Zero, so totally ignore June and Rich.
Cheers!!
ian
