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.
Martin
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?
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?
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.
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.
Magnification is controlled by Scale which you will find on the Page Layout ribbon.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks