Line graph from one cell across many sheets

Hi, 

I have an excel file with many sheets. At the end of the sheets I’ve created a “dashboard” with summary statistics across these multiple sheets. I would like to have a line chart on this “dashboard” sheet that plots the number in one cell across these many sheets so I can see the trend of this number across sheets. There are two many sheets to add each one to a graph so I’d ideally like to plot something like (‘START:END’!B31). Can I do this and how??

Thanks so much! I have searched and haven’t been able to come up with an answer!

By: Jeff

13 thoughts on “Line graph from one cell across many sheets

  1. ig

    excellent issues altogether, you simply received a new reader.
    What would you suggest about your post that you simply made some days in the past?
    Any certain?

  2. http://www.anvir.net

    I know this if off topic but I’m looking into starting my
    own blog and was curious what all is needed to get set up?
    I’m assuming having a blog like yours would cost a pretty penny?

    I’m not very internet smart so I’m not 100% sure.
    Any recommendations or advice would be greatly appreciated.
    Appreciate it

  3. Shavon Landon

    This site is mostly a walk-through for all the data you needed about this and didn’t know who to ask. Glimpse here, and also you’ll positively discover it.

  4. sling tv

    I believe that is one of the such a lot significant information for
    me. And i am satisfied reading your article. However should remark on some general issues, The website taste is
    perfect, the articles is in reality great : D. Just right process, cheers

  5. sling tv

    My brother recommended I might like this website.
    He was totally right. This post actually made my day.
    You cann’t imagine just how much time I had spent
    for this info! Thanks!

  6. sling tv

    Appreciating the time and effort you put into your blog and in depth information you offer.
    It’s great to come across a blog every once in a
    while that isn’t the same outdated rehashed information. Wonderful read!
    I’ve saved your site and I’m adding your RSS feeds to my Google account.

  7. coconut oil

    You actually make it seem so easy with your presentation but I find this matter to be really something that
    I think I would never understand. It seems too complicated
    and very broad for me. I am looking forward for your next post, I’ll try to get the hang of it!

  8. coconut oil

    I’m pretty pleased to discover this web site. I need to to thank you for your
    time for this fantastic read!! I definitely savored every bit of it and I have you bookmarked to look at new information in your website.

  9. ps4 games

    Asking questions are really fastidious thing if you are not understanding anything entirely, but this piece of writing provides nice understanding even.

  10. plenty of fish dating site

    You actually make it seem so easy with your presentation but I
    find this matter to be really something that I think I would never understand.
    It seems too complicated and very broad for me.
    I’m looking forward for your next post, I’ll try to get the hang
    of it!

Comments are closed.