Results 1 to 2 of 2

Thread: Making multiple graphs from one table

  1. #1

    Making multiple graphs from one table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there,


    I have large set of data that I need to make multiple line graphs from, based on what I am filtering on.


    For example, I have something similar to this
    A 13
    A 45
    A 23
    B 65
    B 23
    B 56


    What I would like to do is filter by "A", make a chart with that info, and then, using the same table, filter by "B" and make another chart using that data. Is this at all possible? The issue that I'm having now is that when I unfilter to make the second graph, the first graph doesn't lock in with the original data and changes.


    Any help at all would be much appreciated!

  2. #2
    Hi,

    I send you an example of what I understand. Do you need the same graph updated by the filter of the table?Workbook2.xlsx
    Microsoft Excel Massive Open Online Course.
    Learn all about Microsoft excel in this Online course, with video tutorials, examples of applications and a complete functions and buttons explanation.
    Be part of our community and enjoy learning Excel.

Posting Permissions

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