Urgent help needed for better presentation of Excel Data and Graph formation

Hello Everyone,

I am at present working on the attached sheet I have received from my manager. This sheet is all about availing the loan and then making the investment to generate the revenue out of it.

The sheet should be reformatted to represent the data in a much better way that is easy to understand.

I would need the following graphs against each month:

1."Amount of Interest Payable" and "Total Payable"

2. "Amount Paid" and "Accumulated Payments"

3. "Revenue Generated", "Net Profit" and "Accumulated Net Profit"

The graphs can be a bar chart. For example for the third graph, there will be three adjacent bars standing against for a month.

I am open for the suggestions that makes this sheet presentable in a better way.

Appreciate your help on this.


Who is Participating?
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.

I can suggest the following.

If you use a few numbers or dates, use bars.
if you use a lot of numbers or dates use lines.

if you use dates, make sure that excel take the data as dates, There are some cases that excel takes the data as numbers and do a bad graphic.

Never use 3d Graphics charts

If you want to do a dynamic chart u can use the index function and a scrollbar, see the attachment.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello Amita,

see what you can do with the attached. I have added three charts on a Dashboard sheet. You can choose the month from a drop down. You can also choose to chart more than one month at a time, just enter the number of months to show in C3.

The Revenue chart looks a bit funny because the values are all negative, except for the Revenue.

Is that something you can work with?

cheers, teylyn

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
I have inserted two lines in the table highlighted in yellow to use in the stacked column charts. Created two chart sheets on payments & profits.

Did not know how to graph 1."Amount of Interest Payable" and "Total Payable", as there is only data for 2 months on these, not for every month, but you can use the other two charts as templates for that one.
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

i see the file didn't upload, here it is
deoyagyaAuthor Commented:
Hello Everyone,

I have seen the excel document provided by you. I am very happy to get the quick response. Please allow me some time to review the information / data

I will post my comments as soon as possible.

I truly appreciate your help.

Best Regards,
deoyagyaAuthor Commented:
Dear All,

I shared all the documents to my bos. He linked both the solutions. I am awarding 250 points to each one of you to do a justice :).

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 Excel

From novice to tech pro — start learning today.