Data Analysis with Excel

 Data Analysis


Stock Graph Chart



Series 1 (Blue) represents Stock Quantity - Series 2 (Orange) represents Stock Sold


Each Product/Profit Graph


The graph shows that while profiting from almost every product, having loss from "NISSAN GTR" & "NISSAN R32"

The graph also shows that "MERCEDES C CLASS" has the best profit among all products.


Total Costs Graph


If we look above, we can see the Total costs chart, "Toyota Supra" has the biggest value among all products, while NISSAN GTR & "FORD SHELBY GT500" has the least cost among all products comparing between Total Costs.

Total Sales Graph 


If we look above again, now we can see the pie chart comparison of "Total Sales" among all the products that are listed. Toyota Supra again has the major value on "Total Sales", looking to least gained from sales is the product "NISSAN GTR"










Comments

Post a Comment

Popular Posts