Hi,
I'm trying to produce a scatter plot graph but I want it to be more user friendly.
Is there a way to filter column A to a single option and have the graph display just that data?
The example I attached has only dummy data but the layout is very close.
All help greatly appreciated, I've been trying to solve this one in my spare time for almost a month.
Not sure I understand. If you filter the data only visible rows of data will be shown.
The only change you need to make is to the chart. Format the Chart area and in the Properties section set the chart to not move and resize. That will stop the chart from shrinking when the top rows are filtered.
Hi Andy,
Such a simple fix and here I was trying all the complex solutions.
Thank you so much, this one is solved.
Blaxal
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks