asked on Excel: My Mac Excel graph needs tweaking
My graph needs a bit of help, but first the most obvious errors...
(Excel file below)
![Graph]()
1) the colors for the legend on the right side are in the wrong order. Any idea why?
2) The X-Axis shows correct prices, but I would like them on the hash marks
then, the questions that are about taste.
This is a graph for non-technical people. How does it look?
ThreeYearCosts.xlsx
I think my title is klutsy
Is this better?
Three Year TotalCost
for Four Different Transaction Rates
in $5,000 Monthly Increments
And how about the X-Axis title?
If this can not be very clear for the Experts on EE, it will be very confusing for the target audience.
Thanks.
Here is the Excel file
ThreeYearCosts.xlsx
(Excel file below)
1) the colors for the legend on the right side are in the wrong order. Any idea why?
2) The X-Axis shows correct prices, but I would like them on the hash marks
then, the questions that are about taste.
This is a graph for non-technical people. How does it look?
ThreeYearCosts.xlsx
I think my title is klutsy
Is this better?
Three Year TotalCost
for Four Different Transaction Rates
in $5,000 Monthly Increments
And how about the X-Axis title?
If this can not be very clear for the Experts on EE, it will be very confusing for the target audience.
Thanks.
Here is the Excel file
ThreeYearCosts.xlsx
Microsoft OfficeOffice Suites-OtherMicrosoft 365Office ProductivityMicrosoft Excel
Last Comment
curiouswebster
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Sorry for the confusion.
I changed the 3.5% to be 3% so you must have seen the first version of that post.
Yes, I just want the total cost of a monthly transaction X 36. That is my goal with this chart.
And thanks for the good find on the calculation error on the final column.
I may make another post about the time value of money.
Thanks!
I changed the 3.5% to be 3% so you must have seen the first version of that post.
Yes, I just want the total cost of a monthly transaction X 36. That is my goal with this chart.
And thanks for the good find on the calculation error on the final column.
I may make another post about the time value of money.
Thanks!
As far as the rates...
Those are the rates that a merchant pays to the credit card companies to process the credit cards. So, each month, 3% is taken from their credit card charges, which can be $10K per month.
The three year cost for this would be:
$10K X 3% = $300 X 36 = $10,800
I am not considering the time value of money, but would be happy to if you had an easy formula I could insert into Excel. This would put the three year savings into todays dollars.