+ Reply to Thread
Results 1 to 4 of 4

tables - is it possible to hide the rows, just showing titles??

Hybrid View

  1. #1
    Registered User
    Join Date
    06-05-2012
    Location
    Cork, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    4

    tables - is it possible to hide the rows, just showing titles??

    Hi guys..

    Sorry if something similar has been posted, I've had a look around, but am learning as I go along, and don't even know what I'd be searching for :/..

    I've attached a spreadsheet here where I've tagged a game of football, and listed the actions (goalkick, fouls conceded, crosses, etc.). I've used a scatter graph then to show where these actions happened on the pitch (using a football pitch background on the graph)..

    I've turned the listed actions into a table, so it allows me filter the data shown. In this way the coach can select the info he wants to see, ie. goalkeeper distribution (successful or not), or what sides of the pitch are our team more successful in getting crosses into the box, what side of the pitch are we conceding too many crosses/fouls etc. etc. etc..

    I'm wondering whether it's possible to hide the data in the tables, just showing the titles, and the graph representing whatever's selected? I've tried hiding the rows but when I select something, the list appears once more and the graph drops down out of sight. I'm just really looking for a way to clean up this report, as I'll be attempting a dashboard type thing, showing different kpi's on the one sheet???

    Thanks for any help..
    Adrian.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-05-2012
    Location
    Cork, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: tables - is it possible to hide the rows, just showing titles??

    And of course the attached file didn't work - here's it working :/
    Attached Files Attached Files

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,480

    Re: tables - is it possible to hide the rows, just showing titles??

    Move the chart to the top of the sheet.
    Right click chart and pick Format Chart Area.
    On the Properties tab pick Do not Move or size with cells.

    You can now use the table filters with out affect layout or size of chart, only the data displayed.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    06-05-2012
    Location
    Cork, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: tables - is it possible to hide the rows, just showing titles??

    Thanks Andy - that'll do nicely for now

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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