+ Reply to Thread
Results 1 to 7 of 7

Help with a chart with lots of data

  1. #1
    Registered User
    Join Date
    10-22-2011
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question Help with a chart with lots of data


  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Help with a chart with lots of data

    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

  3. #3
    Registered User
    Join Date
    10-22-2011
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help with a chart with lots of data

    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?

  4. #4
    Registered User
    Join Date
    10-22-2011
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help with a chart with lots of data

    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?

  5. #5
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Help with a chart with lots of data

    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.

  6. #6
    Registered User
    Join Date
    10-22-2011
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help with a chart with lots of data

    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.

  7. #7
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Help with a chart with lots of data

    Magnification is controlled by Scale which you will find on the Page Layout ribbon.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1