This might sound like a simple question but I'm trying to figure out how to possibly hide columns in Excel 2010 but still have the values show up in the graph.
I have a graph of monthly data going back several years, which each month's data showing up in a specific column. I want to hide all the data from before 2010, so the graph only shows the most recent data. Is this possible?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!