Need a few Excel chart ideas

I need to see a few different ways to display the attached spreadsheet.

It contains a crude estimator of the cost for a merchant to accept credit cards, for various levels of monthly transactions and for three different transaction fee rates. I have a column for each of 3%, 4% and 5%.

Those are the costs for 36 months, hence the three year costs.

What kinds of ways can I display this information? I need it to be clear for a person that is not too "graph savvy." My hope is it can help them see what their cost may be, since they know roughly the amount of total charges each month, and likely have a rough idea of the actual transaction fee rate.

With those two data points, I want them to see the three year cost of those transaction fees.


ThreeYearCostsEstimates.xlsx
newbiewebSr. Software EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Karen FalandaysTraining SpecialistCommented:
Since you are using Office 365/Excel 2016, here is the best way to see your options:
* Highlight some or all of the data
* Click the smart tag at the bottom right of the selection to see Quick Analysis tools
*Select Charts and hover over the suggested charts

For data like this, another suggestion is an info graph or pictograph like you see in magazines and newspapers. Decide what the salient info is that you need to convey and construct an image for that. Excel .
 
You can also download free add ins from the Microsoft store to find more options on ways to represent the data
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
newbiewebSr. Software EngineerAuthor Commented:
I have a follow-on question here about me getting the right version of Excel on my Mac...

https://www.experts-exchange.com/questions/29074169/Excel-Need-current-version-for-Mac.html

Feel free to comment :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.