Skip to main content

Apply Graphs to my database spreadsheet

    Graph of two kinds: Left side is a Bar Chart and Right side is a Line Chart

    Pie Chart showing expenses with total and percentage

    Pie Chart showing total expenses

Applying graphs to my database has made it easier for me to visualise the data elaborately. I have applied 3 different kinds of graph to my database. One is a pie chart, then a bar chart and at last a line chart. Out of the 3 kinds of graph I find pie chart to be the most compatible for me to use more often because it is much easier to understand the information and keeps it tidy. I customised my  bar chart also as well as my line chart to easier demonstrate the information I need. Using legends in your graph is also very handy since it will work has a keyword to navigate through the whole graph.

Instruction: To bring up a graph you select your desired cells for example for me it was A3 up to G4 and it bought the data according to that value. Then I selected the tab at the right side with a 'brush icon' which bought up a small pop up with more different styles of pie chart, and with those selection you change the labels from only values to percentage and values, and vice versa. With this same mechanics you can change different designs, labels in other graph such as the line graph and bar chart graph.

Comments

  1. Good work, you have shown that you have understood the basic practical aspect of working with databases and how to visualise data using a pie chart.

    ReplyDelete

Post a Comment

Popular posts from this blog

Tesing my Website Statistics on two sites

    Screenshot : Pingdom Website Speed Test My test 1 was on the pingdom  website speed test and the result has been promising. The performance grade is B standing at 80 points. Website loading time is 2.01 seconds. My website is 70% faster than the similar sites of people who have tested on this website. One thing to know is that pingdom is a very popular website testing site and it is good to know it is quiet faster then those many tested sites. The size of my website is considerable having a 4.2 MB size. The request is 196. So one thing I had trouble was that with the testing destination which I had to choose a country other than UK because the free test which I did has a limited selection of destination. P.S. The template of my website is already developed by Wix(Wix.com) . I just did my own customization on that template and added my content thoroughly. Address for pingdom website : https://tools.pingdom.com     Screenshot: XML-Sit...