Making multiple graphs from one table

[Kitty123]

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!

 

[Pup Denab]

HI Kitty123
Welcome to the forum, this is harder to explain than I thought so i have upload a small excel sheet, so you can see , you need to filter in the picot table, not your original data
Regards
Pup


https://www.dropbox.com/s/7ticg96tbzak0p9/chart kitty.xlsx

 

[Kitty123]

Hi Pup,

I think I may have been a little unclear in my original post. What I have is a table with thousands of lines of data for topics "A", "B", "C", etc. What I would like to do is make hundreds of separate, static graphs for the info for "A", and then for "B", and then for "C", etc. Ideally, I would like to the able to filter the table by which ever topic I want to make a graph about (i.e. "A"), make the graph, and then filter on the next graph that I need to make.

Do you know any way that this would be possible?

Thanks!

 

[Pup Denab]

HI Kitty123
You can create you graph, right click copy, then right click somewhere else on your sheet, paste special, a box should pop up asking you what type of picture you would like to paste, png, is normally used, the data in this picture will not update, as it is only a picture of the graph, is this what you are after, then create your next graph ect, alternatively if you would like all the graphs to update, when new data is added, just make sure you select extra rows when making the graph, you can then copy and paste normally, enter your filter on the pivot table / graph, and repeat for as many graphs as you would like, their is a setting to up date all graphs at once, but with hundreds of graphs, this may take some time
Regards
Pup