Charts and Graphs.<\/strong><\/p>\n\n\n\nIn the example below, we will show how to create an S Curve Graph<\/strong> in Excel.<\/p>\n\n\n\nCreating an S Curve Graph<\/h2>\n\n\n\n To create any type of graph, we need to input data. S Curve Graphs<\/strong> are usually used to present the timeline or progress of a certain activity or a project. For our example, we will use the planned data for a certain project, which will look at the progress per week, and the cumulative progress until it is completed:<\/p>\n\n\n\n <\/figure>\n\n\n\nThere are several ways to create the S Curve Graph<\/strong>, out of this data:<\/p>\n\n\n\n\nWe can select only the data for cumulative results, then go to Insert >> Charts<\/strong>, and then choose the Scatter with Straight Lines and Markers<\/strong> among Scatter Charts<\/strong>:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nWe will, as always, get a preview of our Graph. We can already see an error, i.e. that Excel shows the percentages up to 120 percent<\/strong>.<\/p>\n\n\n\nTo resolve this, we need to click on the labels that show the percentages, right-click on it, and choose Format Axis<\/strong>. We will be shown with the Format Axis window<\/strong> on the right side of the screen, where we can determine our Maximum value<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will change this value to 1<\/strong>, as in for 100 percent<\/strong>.<\/p>\n\n\n\n\nWe can select all of our data, then choose one of the Recommended Charts<\/strong>:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nWe will choose Clustered Column<\/strong> out of the ones that are recommended, and then we will right-click on the created chart and choose Change Chart Type<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOn the window that appears, we will choose a Combo chart<\/strong>. Once we do, we will see a nice preview of the things we want to achieve:<\/p>\n\n\n\n <\/figure>\n\n\n\nWhen we click OK, we will have the desired chart created:<\/p>\n","protected":false},"excerpt":{"rendered":"
Excel is one of the greatest tools for visually presenting the data that we have. The tools best used for this purpose are…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Create an S Curve Graph in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n