I realize this may be easier with pivot tables but for the time being I am trying to accomplish this with a chart.
Cell A78 has a drop down menu, when selecting a title from it, I would like the chart to find the matching text from B55 through B75, then pull the appropriate data values from column C through N.
Is this possible without a macro?
Also, is it possible for the chart title to be updated automatically based on the A78 selection?
1. Add named range "lSeries" with following formula.
Formula:
Please Login or Register to view this content.
2. Go to chart ribbon tools. Hit Select Data.
3. Select series and change "Series Name" reference to...
Formula:Please Login or Register to view this content.
4. Change Series values as following.
Formula:Please Login or Register to view this content.
5. Finally, select the chart title of the chart. Go to Formula bar and enter.
Formula:Please Login or Register to view this content.
See attached.
Edit: Oh I used A column, but it will work with B column as well.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thank you, I like the signature line by the way!
You are welcome and thanks for the rep, and it's my mottoGoes nicely with "Don't work hard, work smart".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks