![]() ![]() However, it does not affect our editorial integrity. The above article may contain affiliate links which help support Guiding Tech. Get a second opinion if you must, but not before exploring the possibilities. If it looks good to you, it will look good to your peers and supervisors. Things usually look pretty tough when you don’t know how, but would you believe that I made the chart below in less than 3 mins?Īll it takes is a little know-how and a quick decisive mind. Master PPT: Read our article on mastering PPT with these great tips, which will go a long way to enhance your skills. There are more options here, to add shadow effects, to give better borders. By far, the easiest way to chart time data is to use a scatter chart. CREAT SCATTER CHART IN EXCEL 2013 WINDOWS 7Images were taken using Excel 2013 on the Windows 7 OS. These features apply to Excel 2007-2013, though the specific steps will vary based on your version. If you want the axes names to be highlighted, I’ve found Layout 3 to be most useful. Here are some tips for editing time and date data in an Excel chart. ![]() If you wish to further enhance it, then go back to the top, click Design and then click Quick Layout and then try out a few layouts that may suit your needs. The same can be done by clicking DESIGN option from the top and clicking at various options, as shown below. Hovering over some of these options will give you a quick idea of what your graph will look like in the end. ![]() If you need to change the look of your graph, then the second option, Style, will come in handy. For example, if it’s a long graph with increasing complexities, it might make sense to keep the box Data Labels checked, as this will indicate values right on the graph itself. The first is Chart Elements which lets you add or remove things which you don’t like. If you hover over it, you see 3 options on the right of the graph. Once your graph is ready, you can edit it further to your liking. So A for example contains 5,000, B contains 7,500, C contains 10,000, and so on and so forth. I have a selection of Groups with different numbers within them. Once all three are selected, hit the OK button and voilà, you have your graph ready. I haven’t been on here for a while but I’ve been tasked with creating two graphs from my data set which is really puzzling me. Make sure that you only select the data and not the name of the column. CREAT SCATTER CHART IN EXCEL 2013 UPDATENext 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. In Excel 2007, 2010 or 2013, you can create a table to expand the data range, and the chart will update automatically. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |