Tags:chart

  • How to Insert a Chart in Word 2016 to Display the Data Intuitively

    Date:2019-10-23 Author:Cordelia

    A chart in your document can convey all the information in a more vivid and visual way than traditional sheet. You may have seen many different kinds of charts in daily life – column, pie, stock, radar, etc. The good news is you can try all styles in Word within several clicks. Here’s a simple guide […]

  • How to Insert a Line Chart in Excel to Show the Data Changes

    Date:2019-10-21 Author:Cordelia

    If you need to make a chart reflecting the changes in specific data, line chart is a good choice. In this post I’ll introduce the way to insert a line chart in Excel. Here’s a table records the incomes of A and B from January to December. 1. Now I want to make a line […]

  • How to Make a Pie Chart in Microsoft Excel 2016

    Date:2019-10-20 Author:Cordelia

    Pie chart is one of the most common used charts in Excel. It’s often used in market share analysis, market occupancy analysis and some other occasions since it can express the proportion of each area intuitively. The way to insert a pie chart in Excel is much like the method of making a line chart, […]

  • How to Change the Type of an Existing Excel Chart

    Date:2019-10-10 Author:Cordelia

    Excel is extremely powerful in processing data, and also enable you to simply convert a spreadsheet of plain text into a more visual chart. And if you’re not satisfied with the representation of an existing chart, you can modify it or even change the chart type any time you want. 1. There’re 2 approaches to […]

  • How to Make a Treemap in Microsoft Excel

    Date:2019-8-20 Author:Cordelia

    Treemap is a simple chart in which you can see the value of each item from the spreadsheet clearly and intuitively. It’s a little bit like pie chart but not that focusing on showing each item’s share of the total. If you’d like to try creating a treemap in your Excel file, here’s the method: […]

  • How to Rotate a Pie Chart in Excel

    Date:2019-8-9 Author:Cordelia

    If you’ve made a pie chart in Excel, you can apply any color or style you like to it easily. But if you’re not satisfied with the location of these slices, how can you rotate the pie chart to finally meet your need? Look at this chart below, the blue slice of A is on […]

  • How to Change the Background of the Chart Area in Excel

    Date:2019-8-5 Author:Cordelia

    If you’ve inserted a chart in the Excel file, you can change the chart style to make it fit your taste. But do you know how to change the background of the chart? The method is also simple. First, open the file, right-click the chart you want to adjust. Please note that if the place […]

  • How to Make an Excel Histogram Display the Data Distribution

    Date:2019-7-10 Author:Cordelia

    Histogram is a direct-viewing type of chart using the width and height of the rectangle to display the frequency distribution of data. It’s very common in daily life and work, which also proves its practicability. Now I want to share the detailed steps to make a histogram in Excel to display the frequency distribution of […]