Now we will change the layout and design of the chart to make the value and scattered dots more prominent. Upon clicking desired type of chart, Excel will automatically create a chart, representing table fields as x-axis, and y-axis respectively, as can be seen in the screen shot below. For this, select the portion of the datasheet, navigate to Insert tab, and from Scatter options, select desired type of chart as shown in the screenshot below. Now we want to create scatter graph which will show distance and time relation. To start off with, launch Excel 2010, open a datasheet for which you want to create Scatter graph and Trend lines.įor instance, we have included a datasheet for which we want to create scatter graph and trend lines, it contains two fields Distance (Km), and Time(Hrs). With this data visualization tool you can help your audience to understand the crux of the datasheet by visually conveying them what data actually means, and most importantly help them to comprehend the trend of your datasheet values. With Scatter graph & Trendlines you will be able to grasp the trend of your data. If you have been caught up in the maze of numbers and values all day long in Excel, then it would be fascinating to create scatter graph for your datasheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |