I have an Excel chart and I need some help with it.
The chart is being used to show the term (years) and value (benefit) of multiple insurance policies. Data is entered in the 5 boxes at the top and the chart changes to show the values entered.
• I want to change the Horizontal axis Start & End values based on the BirthDate (F3) and Policy 1 Coverage Years (C7) on the worksheet.
• I want the bars on the chart to end sharply. Right now they slant down.
There is a 'calculate chart' button that I was using to run some VBA that I was trying - I left the button there, so please link the button to your VBA so that I can update the chart as I change the data in the top boxes.
I've attached a copy of my excel file for review. It has some notes in yellow text blocks.
7 freelancers are bidding on average $28 for this job
Hi, I'll be happy to help you with this project. I will start as soon as you have awarded me the project Please feel free to message me if you need to discuss any questions
Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstrat Mere
I love working with excel formulas and I am not afraid of tedious work. I have experience working with Excel and I am certain i can complete the project on time.