I want to add a chart to my spreadsheet so that when Cell B2 changes (options are 1 or 2 based on radio buttons), then the chart data changes.
IE:
If B2 = 1
Then the chart data range is D5:G7
If B2 = 2
Then the chart data range is D5:L7
I want to do this without VBA. Is there an easy way? I tried plugging in a formula in the data range selector but, obviously, it didn't work.
Hi Josiah
You've posted this in the Programming-VBA Forum and you've indicated...
Perhaps it should be moved to another Forum...Formulas...General??? If you choose to do so, ask a Mod or Adm to move it for you.I want to do this without VBA
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks