How to smooth the angles of line chart in Excel?
Creating charts in Excel is quite easy: Select the data and choose your desired chart type on the ‘Insert’ ribbon. But when it comes to combining two chart types – for example a column chart with a line on top – many users suddenly struggle. Dec 8, 2016 - I would like to create a chart like this on Excel for Mac 2016. When the values in a 2-D chart vary widely from data series to data series, or when. Chart, you could change the data series on the secondary axis to a line chart.
When you insert a line chart in Excel, generally, the line chart is with angles which may be not beautiful and smooth enough. Now I can tell you a way to smooth the angles of the line chart to satisfy your need in Excel.
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by80%
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words...
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum...
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns...
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Create Mailing List and Send Emails by Cell's Value...
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than300 powerful features; Works with Office2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Smooth the line graph
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!
To change the angles of the line to smooth line is very easy, please do as these:
1. Right click the series you need, and select Format Data Series in the context menu. See screenshot:
2. In the Format Data Series dialog, click Line Style in left pane, and check Smoothed line option in right section. See screenshot:
3. Close the dialog. Then you can see the line chart become smooth.
Tip: In Excel 2013, after clicking Format Date Series, go to click Fill & Line tab in the Format Data Series pane, and then go down to check Smoothed line option.
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than300 powerful features. Supports Office/Excel2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features30-day free trial.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
- thank you!!
- To post as a guest, your comment is unpublished.Can we make all lines in chart smooth at the same time? or just able to make one by one?
Thank you - To post as a guest, your comment is unpublished.Thank you sir very very very much! You are a legend!!!!
- To post as a guest, your comment is unpublished.So simple! Can't believe I missed that check box all this time.
1. Problem to be solved
Flat 2D graphs are boring, 3D graphs are hard to read. 2D graphs made to look 3D are the best of both worlds. We’re going to do is add a 3-color linear gradient to the bars and then if desired throw in a background texture to add a little more depth.
Experiment with the colors yourself and the background texture to get something that appeals to you, but most importantly makes your data easy to read so you can make your point with the graph.
And yes, I know, Excel calls them charts but they’re graphs, darn it!
This tutorial was created using Office 2011 for Mac.
1.1 Flat 2D Graph
1.2 3D Graph
Confusing! Can’t read the heights of the bars accurately.
1.3 2D Graph Made to LOOK 3D
2D graph is easy to read the values, but the shading makes it look three dimensional.
2. Create the Initial Graph
2.1 Select Data Range
Select Data Range and then tap on the Charts tab.
Alternatively you can select Insert/Chart… from the menubar.
2.2 Select Chart Type
Tap on Column in the Chart Menu and then choose 2D Column/Clustered Column
2.3 Flat, Ugly 2D Graph
Double tap on one of the blue bars. Alternatively you can tap once on a blue bar and select Format/Data Series…
3. Format the Bars
3.1 This Brings Up the Format Data Series Options
Select Fill from the left sidebar (if it isn’t already selected) and then tap on the Gradient Tab.
3.2 Choose Linear from the Style Pulldown
3.3 Default Goes from blue to white
In order to produce the illusion of 3D, we want the bars to be a darker blue on the left and right, with a light blue in the middle.
The default gradient only has two colors, so we need to add a color to the middle and then change the three colors to the desired dark/light/dark. Select Add Color.
3.4 Change the Center Color
Note the three pointers below the color gradient. You can tell the center color is selected because the center pointer is highlighted. Tap the Color pulldown.
3.5 Select a Lighter Blue for the Center Color
I like Accent 1, Lighter 60% which is the second light one below the darker blue.
3.6 Select the Right Pointer
The left color is already the darker blue color, the center is a light blue so now we need to change the right color to the same darker blue as the left color.
We now need to repeat the process for the right color. Select the right pointer, and again click on the Color pulldown.
3.7 Choose Dark Blue for the Right Color
3.8 You Now Have a Fake 3D Bar
4. Background Texture (Optional)
4.1 Add a Background Texture
Double tap anywhere in the background area of the graph. Alternatively you can choose Format/Chart Area… from the menus.
4.2 Select Picture or Texture
4.3 Select Texture
4.4 Change Transparency to 50%
The default texture is a bit distracting so I dial the transparency up which mutes the effect a bit.