Hi, all! I have spent hours on this but have not figured it out...
I have a data table of sales/costs/profits from 2015 to 2022. What I want to achieve: after users input start year (C2) and end year (C3), the line graph would automatically include the data from start year to end the year. For example, with the start year of 2016 and an end year of 2021, the chart only shows these data.
Anyone can help? Thank you!!
You need to create a parallel set of data that is used for the chart, which uses formulas to determine what data to include. See attached.
Hi, 6StringJazzer, thank you for answering my question! One follow-up: it seems the graph still leaves space for blank cells, is there a way to ignore the blank cells? Thanks!
Hi, all! I have spent hours on this but have not figured it out...
I have a data table of sales/costs/profits from 2015 to 2022. What I want to achieve: after users input start year (C2) and end year (C3), the line graph would automatically include the data from start year to end the year. For example, with the start year of 2016 and an end year of 2021, the chart only shows these data.
Anyone can help? Thank you!!
Thread moved to the VBA section. Please don't open duplicate threads - your other thread on this has been closed and the post from it copied here. Thanks.
Last edited by AliGW; 03-11-2022 at 04:03 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You don't need VBA for this. Just create Dynamic Named Ranges for years, sales, costs and profits. Then use those in the chart rather than static ranges.
See the updated example. The DNR are described in rows 10 to 13. If you are using Excel 365, take the comments off to see them work in real time.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Is this now resolved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks