• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 93
  • Last Modified:

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
0
newbieweb
Asked:
newbieweb
1 Solution
 
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
 
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
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now