Forum Discussion
Move Rows based on Date
Riny_van_Eekelen Well, this is something I hadn't thought about, mostly because this is also going to include graphs. When I add my graphs, when I do my filters, can I make the graphs change with the filtering?
FrameofLightDesigner I believe you can. What kind of graphs did you have in mind? You can create pivot tables / pivot charts on the basis of the Complete list.
Riny_van_Eekelen So each orchid has different care requirements. So I want the graph to reflect the "average" care requirements necessary, but also a graph showing the orchid types I have.
FrameofLightDesigner Possible. Where and how do you intend to keep the "care" information? And when you talk about "types" of orchids, do you then refer to "Genre"? If so, you are dealing with 82 unique genres in the table. That's quite a lot of data labels if you want to capture all of them in a graph.
Anyhow, I've added a pivot table and a graph with a slicer and a timeline, just to demonstrate the principle. Not very pretty, though, and probably not very meaningful either. Have a look and see if this is something worth pursuing.
Riny_van_Eekelen Sir! You have some serious skills! I love your excel style! The one thing I need to do is input the proper care information for each orchid type so that the "average" can be automated. The one thing I'm struggling with, with that, is if I should do that by tab? Or would a table be best? I'm thinking table, because the headings are what the graph would pull from. If I'm correct, I can make a new worksheet called "Orchid Care" and then create a table with the proper headings and input the proper information. I say a new worksheet because I know it will help with organization and cleanliness. I know it's not completely necessary.
Thoughts?