In Progress

Excel VBA - Charts and Graphs

Ok here is what I need.

A formula to calculate the predominant sales price RANGE for the last 12 months (Cell B38). I'm not sure what the best way to do this would be. Perhaps find the median and then go 10% above and 10% below?

A new formula to calculate the predominant age range over last 5 years (cell G34) - Again, not sure the best way to tackle this calculation but the age range needs to be fairly tight, 10 years tops.

In the Active and Sold Stats section there is the line Average for all the different metrics. What I'm really looking for here is the Typical, not really the average. Any thoughts on that? It's really another predominant thing like above.

CHARTS AND GRAPHS

Once we solve the above calculations issues, I'd like the charts/graphs to start on the next pages down (3rd page). The charts should appear in portrait view just as the rest of the data is presented and should stretch from edge to edge (left to right) so they are as large as possible. You should probably be able to fit at lest 3 charts per page. Here is what I need graphed out:

Bar Graph - Number of Homes sold per quarter over last 5 years.

Bar Graph - Number of New Construction Homes sold per quarter over last 5 years.

Bar Graph - Median Sale Price of Homes sold per quarter over last 5 years.

Bar Graph - Median Price Per Sqft of Homes sold per quarter over last 5 years.

Bar Graph - Median DOM per quarter over last 5 years.

I've attached the newest version of the Excel doc.

Skills: Excel, Visual Basic

See more: vba graphs tight, vba charts graphs, excel charts graphs vba, vba charts, excel vba graphs, what graph, visual age, graphs c, graphs data, graph graphs, graph edge, edge homes, edge graph, data graphs, c graphs, best graphs data, best graphs, a graphs, vba excel charts graphs, excel vba graph, vba excel charts, vba right, vba for, right vba, line graph excel

About the Employer:
( 15 reviews ) Austin, United States

Project ID: #1113621

Awarded to:

mfernwood

Please refer to PM for bid proposal.

$100 USD in 2 days
(2 Reviews)
2.8

5 freelancers are bidding on average $106 for this job

fedalal2

Hi, I have more 10 years experience in MS Excel and MS Office automation, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex

$150 USD in 2 days
(32 Reviews)
5.5
chriskerpini

Very experienced in Excel formulas & VBA - 10 years (teaching). Please check PM.

$80 USD in 2 days
(12 Reviews)
4.4
telemarketing555

Hi, please check your PM. Thank you.

$151 USD in 1 day
(26 Reviews)
4.4
Martina28

plz check inbox

$100 USD in 4 days
(0 Reviews)
0.0
pie743

I'm an experienced finance professional with extensive knowledge of Excel and VBA. I can do this. Please check private message. Thanks.

$50 USD in 5 days
(0 Reviews)
0.0