Help with a chart with lots of data

**Ecloud** · 10-22-2011, 02:21 PM

**mrice** · 10-22-2011, 02:35 PM

It would be worth looking at Andy Pope's site and the examples of charts to see if there is anything there that you like the look of.

http://www.andypope.info/charts.htm

Incidentally, the COUNTIF formula that you used could be simplified.

Please Login or Register  to view this content.

**Ecloud** · 10-22-2011, 03:41 PM

Thank you for the link. I looked over what he had, and I think that I will most likely stick with the format of what I have so far.

Thanks also for the simplification regarding the COUNT IF. I am wondering if at this point, it would be best for me to simply make the chart the full printable size on the paper. Is there a way for me to hide the previous two columns, or just put that chart onto another worksheet, then blow it up to full size to print?

**Ecloud** · 10-23-2011, 01:26 AM

I have managed to find information on how to move/copy my table onto another worksheet by itself. I am now trying to change the size of the table so that it fills the entire print area, i.e. make the table as big as possible. Does anyone know how I can do this without just dragging the box size?

**mrice** · 10-23-2011, 11:44 AM

Suggest that you set the print area to be the table that you are interested in and then use page set up to control the magnification.

**Ecloud** · 10-23-2011, 08:24 PM

Oh, thank you. I will give that a try. I know how to set a print area so that should be easy for me. I will then go to page setup to control the size...is there a magnification option there that you are talking about when it comes to changing the size? I hope I am not being too frustrating...I know how that can be sometimes when you're trying to help.