Make sure that you only select the data and not the name of the column. Next is selecting the X values and Y values for the series and that can easily be done by selecting the data from the respective columns. Once it’s blank, go ahead and click Add and here select the Series Name as the name of the chart, which I had named as Chart: Year v/s Inflation %. If you have anything in the box titled Legend Entries (Series) then select it and hit Remove. So, right click on the space which gets created when you click on the graph and choose Select Data. Once you click on any chart, the basic idea is to have the data sorted on X and Y axes as planned. If you’re unsure, you can change it later, so let’s not worry too much about it now. Once your data is ready, click on the Insert tab from the options at the top and then ponder a minute trying to see which graph fits best for your presentation. I’ve given the name ( Chart: Year v/s Inflation %) right below my data, but you can do so anywhere. It’s best to give a name to the chart that may or may not be part of a bigger presentation. It’s random numbers, but you should get an idea of how you can incorporate this in your own graph. For my example, I’ve chosen Year v/s Inflation % for each year. Open a blank Excel sheet and decide your X axis and Y axis data. Like any other MS Excel trick, you have to start somewhere. If you have your data right, you can just arrange it in any number of rows and columns and get a graphical representation of your data. Want brilliant looking graphs like these? Read on | Shutterstock And the next step would be to realize that mastering graphs on Microsoft Excel is actually not all that hard. Have a presentation at work/school involving graphs and you have no idea how to make them? Well, step 1 would be to breathe and calm down for a bit.
0 Comments
Leave a Reply. |