[Webinar] Streamline your web hosting managementRegister Today

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

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.


2 Solutions
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
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.
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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 :).


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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