Categories
Life hack

How to make a curved graph in excel

How to make a curved graph in excel

When you create a line graph in Excel, the lines are angled and have hard edges by default. You can easily change this to a curved graph with nice, smooth lines for a more polished look. We’ll walk you through the process step by step to convert your graph.

In this example, we want to create a curved line graph from this data on cookie sales.

Select and highlight the range A1:F2 and then click Insert > Line or Area Chart > Line.

How to make a curved graph in excel

The line graph is inserted with straight lines corresponding to each data point.

How to make a curved graph in excel

To edit this to a curved line, right-click the data series and then select the “Format Data Series” button from the pop-up menu.

How to make a curved graph in excel

Click the “Fill & Line” category and then check the box for “Smoothed Line.”

How to make a curved graph in excel

Using a smoothed line can help make your line graphs look smarter and more professional.

How to make a curved graph in excel

Smoothed lines can also be a clever way of distinguishing one data series from another. For example, targets from actuals or last year to this year.

Create a Normal Distribution Chart (Bell Curve) in Excel:

In this article, we are going to learn how to Create a Normal Distribution Chart (Bell Chart) in b365 using Kutools.

You can create a Normal Distribution Chart in Excel for analyzing the probability of the events. For that, you can calculate Average, Standard Deviation, and normal distribution using formulas. But with the help of kutools feature, you can create it quickly.

Jump To:

  • Steps to Create a Normal Distribution Chart (Bell Curve) in Excel
  • A Brief Summary

Steps to Create a Normal Distribution Chart (Bell Curve) in Excel:

  • First, you need to Select the Data to apply the Bell Curve or Normal Distribution.
  • On the Kutools tab, Select Charts option and it will open the menu.
  • Choose the Normal Distribution/Bell Curve Option from the menu.
  • It will open Quickly Create Normal Distribution Chart dialog box, in that Dialog box, max value, min value, and standard deviation has been calculated and listed.
  • In this dialog box, Check the Normal distribution chart option under the Select section.
  • Specify the title for the Chart using Chart Title input box.
  • Hit the Ok button.

Now, the Normal Distribution Chart has been created in the Excel spreadsheet.

  • Frequency Histogram Chart – In Quickly Create Normal Distribution Chart, if you select both the Normal Distribution chart and Frequency histogram chart, it will create a combo chart like the below image.
  • If you select the Frequency Histogram Chart option only, then it will create the chart like the below example.
  • Output Data Option – If you click this button, it will display the calculated data in the new worksheet.
  • Sample button – If you want to see the example of a Normal distribution chart for your reference, use this button.

A Brief Summary:

I hope, this article helped you to understand the steps to Create a Normal Distribution Chart (Bell Curve) in Excel 365 using Kutools. Kindly, share your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!

How to make a curved graph in excel

Related Articles

  • How to Get the Area Between Curves in Excel
  • How to Find the Tangent on a Graph in Excel
  • How to Use Graph Callouts in PowerPoint
  • How to Make a Cumulative Chart in Excel
  • How to Make a Sales Analysis on a Spreadsheet
  • How to Find Dispersion on Excel

The world in which your business operates is constantly changing. Capturing the state of your business once a month may not reflect the reality of your situation. Fortunately, in Microsoft Excel you can add fitted curves and trendlines to help you track gradual changes in your business conditions rather than only large shifts.

Step 1

Open an existing Microsoft Excel spreadsheet containing the data you wish to graph and fit to a curve, or create a new spreadsheet and enter your data.

Step 2

Open the “Insert” tab and select “Chart” to create a chart containing the individual data point on which you will plot the fitted curve. Common formats include the XY Scatterplot, Column and Area.

Step 3

Select the data columns in your spreadsheet corresponding to the X (dependent) and Y (independent) values of the data. The X-axis commonly corresponds to time and the Y-axis commonly corresponds to a value such as sales, cost, profit or revenue.

Step 4

Open the “Chart” menu and select “Add Trendline.” This will plot a line showing the trend of the data on the graph calculated using a moving average or similar algorithm. This helps you see how the data evolves over time without the effort and constraint required to fit the data to a statistical model. Select and then right-click on the trendline to change the format.

Step 5

Select the “Display equation on chart” option under the Fit Trendline dialog box to change the model used to calculate the trendline. You can choose from lineal, exponential, logarithmic and polynomial models to match your data. Least-squares curve fitting is used to calculate the optimal model fit to the data.

  • Microsoft Office: Create a Chart From Start to Finish
  • Newton Excel Bach: Using LINEST for Non-linear Curve Fitting

Chris Daniels covers advances in nutrition and fitness online. Daniels has numerous certifications and degrees covering human health, nutritional requirements and sports performance. An avid cyclist, weightlifter and swimmer, Daniels has experienced the journey of fitness in the role of both an athlete and coach.

Summary

A bell curve is a plot of normal distribution of a given data set. This article describes how you can create a chart of a bell curve in Microsoft Excel.

More Information

n the following example you can create a bell curve of data generated by Excel using the Random Number Generation tool in the Analysis ToolPak. After Microsoft Excel generates a set of random numbers, you can create a histogram using those random numbers and the Histogram tool from the Analysis ToolPak. From the histogram, you can create a chart to represent a bell curve.

To create a sample bell curve, follow these steps:

Enter the following column headings in a new worksheet:

A1:Original B1:Average C1:Bin D1:Random E1:Histogram G1:Histogram

Enter the following data in the same worksheet:

Enter the following formulas in the same worksheet:

These formulas will generate the average (mean) and standard deviation of the original data, respectively.

Enter the following formulas to generate the bin range for the histogram:

This generates the lower limit of the bin range. This number represents three standard deviations less than the average.

This formula adds one standard deviation to the number calculated in the cell above.

Select Cell C3, grab the fill handle, and then fill the formula down from cell C3 to cell C8.

To generate the random data that will form the basis for the bell curve, follow these steps:

On the Tools menu, click Data Analysis.

In the Analysis Tools box, click Random Number Generation, and then click OK.

In the Number of Variables box, type 1.

In the Number of Random Numbers box, type 2000.

Note: Varying this number will increase or decrease the accuracy of the bell curve.

In the Distribution box, select Normal.

In the Parameters pane, enter the number calculated in cell B2 (29 in the example) in the Mean box.

In the Standard Deviation box enter the number calculated in cell B4 (14.68722).

Leave the Random Seed box blank.

In the Output Options pane, click Output Range.

Type D2 in the Output Range box.

This will generate 2,000 random numbers that fit in a normal distribution.

To create a histogram for the random data, follow these steps:

On the Tools menu, click Data Analysis.

In the Analysis Tools box, select Histogram, and then click OK.

In the Input Range box, type D2:D2001.

In the Bin Range box, type C2:C8.

In the Output Options pane, click Output Range.

Type E2 in the Output Range box.

To create a histogram for the original data, follow these steps:

On the Tools menu, click Data Analysis.

Click Histogram, and then click OK.

In the Input Range box, type A2:A9.

In the Bin Range box, type C2:C8.

In the Output Options pane, click Output Range.

Type G2 in the Output Range box.

Create labels for the legend in the chart by entering the following:

Select the range of cells, E2:H10, on the worksheet.

On the Insert menu, click Chart.

Under Chart type, click XY (Scatter).

Under Chart sub-type, in the middle row, click the chart on the right.

Note: Just below these 5 sub-types, the description will say “Scatter with data points connected by smoothed lines without markers.”

Click the Series tab.

In the Name box, delete the cell reference, and then select cell E15.

In the X Values box, delete the range reference, and then select the range E3:E10.

In the Y Values box, delete the range reference, and then select the range F3:F10.

Click Add to add another series.

Click the Name box, and then select cell E14.

Click the X Values box, and then select the range E3:E10.

In the Y Values box, delete the value that’s there, and then select the range G3:G10.

Click Add to add another series.

Click the Name box, and then select cell E16.

Click the X Values box, and then select the range E3:E10.

Click the Y Values box, delete the value that’s there, and then select the range H3:H10.

The chart will have two curved series and a flat series along the x-axis.

Double-click the second series; it should be labeled “- Bin” in the legend.

In the Format Data Series dialog box, click the Axis tab.

Click Secondary Axis, and then click OK.

You now have a chart that compares a given data set to a bell curve.

References

For more information about creating charts, click Microsoft Excel Help on the Help menu, type create a chart in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Summary

A bell curve is a plot of normal distribution of a given data set. This article describes how you can create a chart of a bell curve in Microsoft Excel.

More Information

n the following example you can create a bell curve of data generated by Excel using the Random Number Generation tool in the Analysis ToolPak. After Microsoft Excel generates a set of random numbers, you can create a histogram using those random numbers and the Histogram tool from the Analysis ToolPak. From the histogram, you can create a chart to represent a bell curve.

To create a sample bell curve, follow these steps:

Enter the following column headings in a new worksheet:

A1:Original B1:Average C1:Bin D1:Random E1:Histogram G1:Histogram

Enter the following data in the same worksheet:

Enter the following formulas in the same worksheet:

These formulas will generate the average (mean) and standard deviation of the original data, respectively.

Enter the following formulas to generate the bin range for the histogram:

This generates the lower limit of the bin range. This number represents three standard deviations less than the average.

This formula adds one standard deviation to the number calculated in the cell above.

Select Cell C3, grab the fill handle, and then fill the formula down from cell C3 to cell C8.

To generate the random data that will form the basis for the bell curve, follow these steps:

On the Tools menu, click Data Analysis.

In the Analysis Tools box, click Random Number Generation, and then click OK.

In the Number of Variables box, type 1.

In the Number of Random Numbers box, type 2000.

Note: Varying this number will increase or decrease the accuracy of the bell curve.

In the Distribution box, select Normal.

In the Parameters pane, enter the number calculated in cell B2 (29 in the example) in the Mean box.

In the Standard Deviation box enter the number calculated in cell B4 (14.68722).

Leave the Random Seed box blank.

In the Output Options pane, click Output Range.

Type D2 in the Output Range box.

This will generate 2,000 random numbers that fit in a normal distribution.

To create a histogram for the random data, follow these steps:

On the Tools menu, click Data Analysis.

In the Analysis Tools box, select Histogram, and then click OK.

In the Input Range box, type D2:D2001.

In the Bin Range box, type C2:C8.

In the Output Options pane, click Output Range.

Type E2 in the Output Range box.

To create a histogram for the original data, follow these steps:

On the Tools menu, click Data Analysis.

Click Histogram, and then click OK.

In the Input Range box, type A2:A9.

In the Bin Range box, type C2:C8.

In the Output Options pane, click Output Range.

Type G2 in the Output Range box.

Create labels for the legend in the chart by entering the following:

Select the range of cells, E2:H10, on the worksheet.

On the Insert menu, click Chart.

Under Chart type, click XY (Scatter).

Under Chart sub-type, in the middle row, click the chart on the right.

Note: Just below these 5 sub-types, the description will say “Scatter with data points connected by smoothed lines without markers.”

Click the Series tab.

In the Name box, delete the cell reference, and then select cell E15.

In the X Values box, delete the range reference, and then select the range E3:E10.

In the Y Values box, delete the range reference, and then select the range F3:F10.

Click Add to add another series.

Click the Name box, and then select cell E14.

Click the X Values box, and then select the range E3:E10.

In the Y Values box, delete the value that’s there, and then select the range G3:G10.

Click Add to add another series.

Click the Name box, and then select cell E16.

Click the X Values box, and then select the range E3:E10.

Click the Y Values box, delete the value that’s there, and then select the range H3:H10.

The chart will have two curved series and a flat series along the x-axis.

Double-click the second series; it should be labeled “- Bin” in the legend.

In the Format Data Series dialog box, click the Axis tab.

Click Secondary Axis, and then click OK.

You now have a chart that compares a given data set to a bell curve.

References

For more information about creating charts, click Microsoft Excel Help on the Help menu, type create a chart in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

How to make a curved graph in excel

Related Articles

  • How to Get the Area Between Curves in Excel
  • How to Find the Tangent on a Graph in Excel
  • How to Use Graph Callouts in PowerPoint
  • How to Make a Cumulative Chart in Excel
  • How to Make a Sales Analysis on a Spreadsheet
  • How to Find Dispersion on Excel

The world in which your business operates is constantly changing. Capturing the state of your business once a month may not reflect the reality of your situation. Fortunately, in Microsoft Excel you can add fitted curves and trendlines to help you track gradual changes in your business conditions rather than only large shifts.

Step 1

Open an existing Microsoft Excel spreadsheet containing the data you wish to graph and fit to a curve, or create a new spreadsheet and enter your data.

Step 2

Open the “Insert” tab and select “Chart” to create a chart containing the individual data point on which you will plot the fitted curve. Common formats include the XY Scatterplot, Column and Area.

Step 3

Select the data columns in your spreadsheet corresponding to the X (dependent) and Y (independent) values of the data. The X-axis commonly corresponds to time and the Y-axis commonly corresponds to a value such as sales, cost, profit or revenue.

Step 4

Open the “Chart” menu and select “Add Trendline.” This will plot a line showing the trend of the data on the graph calculated using a moving average or similar algorithm. This helps you see how the data evolves over time without the effort and constraint required to fit the data to a statistical model. Select and then right-click on the trendline to change the format.

Step 5

Select the “Display equation on chart” option under the Fit Trendline dialog box to change the model used to calculate the trendline. You can choose from lineal, exponential, logarithmic and polynomial models to match your data. Least-squares curve fitting is used to calculate the optimal model fit to the data.

  • Microsoft Office: Create a Chart From Start to Finish
  • Newton Excel Bach: Using LINEST for Non-linear Curve Fitting

Chris Daniels covers advances in nutrition and fitness online. Daniels has numerous certifications and degrees covering human health, nutritional requirements and sports performance. An avid cyclist, weightlifter and swimmer, Daniels has experienced the journey of fitness in the role of both an athlete and coach.

Adding a graph in a spreadsheet is no big deal as long as you know the process. However, do you know that you can make a curved line graph in Excel or Google Sheets? If no, you should check out this tutorial to turn the sharp edges into smoothed lines.

Sometimes you may need to insert a graph in a spreadsheet to show data more beautifully. A graph or chart makes the spreadsheet productive and attractively visualizes the data. It is straightforward to create and add a graph – whether you are using Microsoft Excel or Google Sheets. The problem with the default graph is the sharp edges. Although it defines the exact ups and downs of your data, some people do not like it. If you are one of them, you can smoothen the edges by following this guide. For your information, you can convert existing sharp edges of a graph into a smoothen corner as well as add a new curved graph. Either way, you do not need any third-party add-on.

How to make a curved line graph in Excel

To make a smooth curved line graph in Excel, follow these steps-

  1. Enter your data in the spreadsheet and select it to make a graph.
  2. Go to Insert tab and insert a 2-D line graph.
  3. Right-click on the line and select the Format Data Series.
  4. Go to Fill & Line tab.
  5. Check the Smoothed line option.

To get started, you need to enter your data that you want to use to create the graph. After that, go to Insert tab and click the Insert Line or Area Chart button in the Charts section. After that, select a 2-D Line graph that you want to display in your spreadsheet.

After inserting the graph, right-click on the blue line, and select Format Data Series option.

On your right side, you should see a panel from where you need to switch to the Fill & Line tab. After that, make a tick in the Smoothed line checkbox.

You can find the conversion immediately.

How to make a curved line graph in Google Sheets

To make a curved graph in Google Sheets, follow these steps-

  1. Enter all data and insert a chart.
  2. Convert the Chart into Line.
  3. Select Smooth from the Customize tab.

First of all, you need to create a spreadsheet with the proper data. Then, select all the data, click the Insert button, and select Chart from the list.

By default, it shows a chart as per your data. You need to convert it to a line graph. For that, click on the Chart, expand the Chart type drop-down menu, and select something under the Line label.

Now, go to Customise tab, and expand the Chart style menu. Following that, make a tick in the Smooth checkbox.

Now, the sharp edges should be changed.

That’s it! Hope this tutorial will be helpful.

Replies (5) 

As you seem to have discovered that isn’t an option in Excel 2011.

You can get a similar effect if you:

  1. Format the Chart with No Line with Fill of your choice
  2. Center the Chart on a rounded corner rectangle of the same color
  3. Group the Chart & the Shape

AI: Artificial Intelligence or Automated Idiocy.
Please mark Yes/No as to whether a Reply answers your question.

1 person found this reply helpful

Was this reply helpful?

Sorry this didn’t help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Was this reply helpful?

Sorry this didn’t help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Was this reply helpful?

Sorry this didn’t help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I create (template) charts with Round Corners on Mac Excel 2004 (11.6.6). Excel 2004 has the Round Corner option.

Select the chart

Format (pull down menu)

Selected Chart Area…

Round Corner check box (at bottom)

Save the template sheet, close Excel 2004, then open the template sheet with Excel 2011. Copy and Paste the chart to the sheet where you want the chart. The corners remain round and look outstanding.

With the chart now on Excel 2011, change the chart’s source data to the sheet where the chart now resides.

Top Excel Menu Bar… select

Y Values (change source for each Series to match the new sheet)

By How to make a curved graph in excelMadhuri Thakur | Reviewed By How to make a curved graph in excelDheeraj Vaidya, CFA, FRM

Normal distribution graph in excel is used to represent the normal distribution phenomenon of a given data, this graph is made after calculating the mean and standard deviation for the data and then calculating the normal deviation over it, from excel 2013 versions it has been easy to plot the normal distribution graph as it has inbuilt function to calculate the normal distribution and standard deviation, the graph is very similar to the bell curve.

Excel Normal Distribution Graph (Bell Curve)

A normal distribution Graph is a continuous probability function. We all know what probability is; it is a technique to calculate the occurrence of a phenomenon or a variable. A probability distribution is a function that is used to calculate the occurrence of a variable. There are two types of probability distributions, Discreet and continuous.

The basic idea of what is a normal distribution is explained in the overview above. BY definition, a normal distribution means how evenly the data is distributed. A continuous probability distribution is used to calculate real-time occurrences of any phenomenon. In mathematics, the equation for a probability distribution is as follows:

Seems so complex, right? But excel has made it easier for us to calculate normal distribution as it has a built-in function in excel of the normal distribution. In any cell type, the following formula,

It has three basic factors to calculate the normal distribution in excel:

  1. X: X is the specified value for which we want to calculate normal distribution.
  2. Mean: Mean is whereas average of the data.
  3. Standard_Dev: Standard Deviation is a function to find the deviation of the data. (It has to be a positive number)