Posts

Let’s take a look. If you should probably apply subscript or superscript formatting, you won’t find these options on the ribbon. Instead, they’re located on the Font tab of the Format Cells dialog box in the Effects group. To apply either subscript or superscript, you better follow a particular process. it’s possible for you to’t just select a cell normally and apply one of these formats. There are two ways to apply subscript or superscript....

Every day, thousands of questions about Excel are posted on the internet. Many go unanswered because they are unclear, or too complicated to understand. Below are six tips to write a better question that will attract good answers quickly. State your goal clearly and briefly Be clear about what you want. For example: 3. Reduce and simply Less is more. Do not venture to explain your requirements at length in text....

Stacked area charts make sense when you want to show changes in a part-to-whole relationship over time. 100% stacked charts are focused on proportions, at the expense of actual values. First, I’ll select data, excluding totals. Then I’ll use recommended charts to insert a stacked area chart. The result shows total sales, and how much each product line contributes to total sales. The vertical axis is automatically scaled to fit the data, in units of $5000....

The result is a chart that shows a proportional breakdown of each quarter by region. Looking at the chart, you might wonder how to show the actual percentages in each bar? This isn’t hard to do, but it does take a little prep work. But there is an option to pull values from other cells. To start off, I’ll copy and paste the whole table and remove the values. In other words, I need to divide C5 by the sum of C5 to F5....

A 100% stacked column chart is a sub jot down of a regular stacked column chart. In this worksheet, we have quarterly sales data broken down by region and quarter. To start off, I’ll create a normal stacked column chart. I’ll flip the chart with the Switch Column/Rows button to group sales by quarter instead of by region. Now before we look at the 100% stacked option, let’s review this chart....

Let’s plot this data in a bar chart. you might see we have the count for each response, with a little over 1900 responses total. Now let’s plot just the counts. I’ll select only the count data, excluding totals, then click Recommended charts. Then I’ll choose the bar option. I then just have to go for the bar chart and click OK. This is a good start. Now let’s add a title....

A clustered column chart groups multiple date series by category in vertical columns. Clustered column charts make it easy to spot trends. Note that the horizontal axis labels come from row 4. The Select Data window will also confirm the legend and category axis labels. To change the grouping to quarters, use the switch columns and rows button. Now data series comes from regions, and columns are clustered by quarter....

We’ll also look at custom number formats to show dates as month names, and currency in thousands. Here we have data for monthly sales of a small business for the year 2016. Let’s build a column chart to plot this data. Now let’s make this a better chart. First, I’ll add a descriptive title. Now I’ll fatten up the columns a bit. Column width is adjusted by changing gap width under Series options....

What is a combo chart? A combo chart is just a name for a chart that uses more than one chart key in. For example, a column chart combined with a line chart. Here we have annual financial data for Google, including Revenue, Net Income, and Profit Margin. This is a case where the label “Year” confuses Excel because it suggests a data series. We could fix this using Select Data…...

you’re able to download the worksheet I used in the training below. It’s a great way to develop strong formula skillswithouta huge time investment. you might getCore Formula aloneorin a course bundle(save 15%). Need some good reasons to learn formulas?

Here we have historical, 30-year mortgage interest rates going back to 1971. Let’s plot this data in a line chart. Line charts are especially good at visualizing trends over time. The first option is the one I want. The result is a simple line chart. This is a great example of the simplicity of a line chart. Now let’s clean up the chart. First, I’ll work on the vertical axis....

Here we have data that shows market share for desktop browsers in 2016. Let’s build a pie chart to plot this data. Just select and copy the data, then use Paste Special with Transpose. Then remove the original data. Now we’re ready to make the pie chart. I’ll use Insert, then go for the pie chart option. Excel builds the chart. As always there’re some things here we want to change....

All categories are rated on the same 5-point scale, where 1 is poor and 5 is excellent. You won’t find radar charts in Recommended Charts. However, you’re able to switch to All charts and insert from there. Alternately, you’re able to use the small icon on the Insert tab of the ribbon. You’ll find radar charts below surface charts. The result is a closed geometric shape that represents data in all categories at once....