troubleshooting Question

Excel: My Mac Excel graph needs tweaking

Avatar of curiouswebster
curiouswebsterFlag for United States of America asked on
Microsoft OfficeOffice Suites-OtherMicrosoft 365Office ProductivityMicrosoft Excel
5 Comments3 Solutions284 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Rob Henson
Finance Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros