?
Solved

Complex Graphic

Posted on 2013-05-31
2
Medium Priority
?
308 Views
Last Modified: 2013-06-01
EE Pros,

I have a graphic that is going to be simple for the right EE Pro.  I've constructed a example of what I'm looking for that keeps the cost/expense number constant while the "helper" cell demonstrates moving from "Conservative", to "Aggressive".  

What I need is the graphic representation that is reflected when the macro is executed.

See if this makes sense.

B.
Complex-dynamic-graphic.xlsm
0
Comment
Question by:Bright01
2 Comments
 
LVL 81

Accepted Solution

by:
byundt earned 2000 total points
ID: 39212277
I suggest using a column chart rather than a line chart.
Column chart
I find nested IF statements confusing, and try to use other approaches to avoid them. In this case, the INDEX function is perfect:
=INDEX(D8:F8,I$4)                'Succinct
=IF(I4=1,D8,IF(I4=2,E8,IF(I4=3,F8)))         'Confusing, isn't it
Complex-dynamic-graphic.xlsm
0
 

Author Closing Comment

by:Bright01
ID: 39212880
Byundt,

Thank you!  Well done.  And I'm starting to get the hang of using Indexing.  Great recommendation.

Best regards,

B01
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This tutorial is about creating a new Microsoft Online User Profile account along with how to transfer your files and settings. You may be faced with this situation if your existing user profile has become corrupted.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question