Displaying 1-20 of 77 results
Exclusive
SIMPLE BUT EFFECTIVE TABLES
Simple but effective tables, part 9
- Article
- 09 Sep 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. The previous two-part article looked at the use of structured references to refer to all or part of an Excel Table, from cells outside of the Table as well as cells within the Table. We are going to conclude our exploration of Tables by looking at Filtering and Sorting, and using Sparklines and check boxes in Table columns. Then, in the next part of the series, we will look at how Tables work with Power Query.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #489 – The basics of charts in Excel part 2: Combo charts
- Article
- 08 Apr 2024
- Tom Edmunds
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post exploring the concept of a combo chart in Excel that can be used for two or more series of data.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #488 – The basics of charts in Excel
- Article
- 11 Mar 2024
- Thomas Edmunds
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post exploring the basics of the different chart types in Excel.
Exclusive
Enhancing data display and entry with Excel Form Controls
- Webinar
- 13 Nov 2023
Form Controls are objects that can be used to display data or make it easier for users to enter data, to perform an action or to make a selection.
Exclusive
Histogram Hiccoughs part 2
- Article
- 27 Oct 2023
- Liam Bastick
Last time, I provided several reasons why Excel’s built-in Histogram charts can cause problems. This time, I consider workarounds to achieve the same visualisations.
Exclusive
Histogram Hiccoughs Part 1
- Article
- 27 Oct 2023
- Liam Bastick
The Histogram chart helps us to analyse the distribution of the data, where we have many data points that can be grouped into categories, or “buckets”. We begin by looking at the standard Excel Histogram chart, which is available in Excel 2016 onwards.
NEW TECH FEATURES
New tech features for Jun - Aug 2023
- Article
- 11 Sep 2023
- David Benaim
David Benaim presents a digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three month.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #477 - Introduction to creating map charts in Excel
- Article
- 14 Aug 2023
- Thomas Edmunds
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post which explores how to create map charts using Excel.
Exclusive
EXCEL TIP OF THE WEEK
TECH NEWS
Excel Tips & Tricks #468 – Refreshing dealing with Objects
- Article
- 16 Mar 2023
- Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week we have a General User post where we take a look at how to insert and deal with objects including images, charts, or files in Excel.
Exclusive
EXCEL TIP OF THE WEEK
TECH NEWS
Excel Tips & Tricks #465 - Using #N/A in charts redux
- Article
- 02 Feb 2023
- Bani Lamba
Hello all and welcome back to the Excel Tips & Tricks! This week we have a Creator level post in which we're taking a look at how to make use of the #N/A error to help customise charts. This was previously covered in Tip #297.
TECH NEWS
Risk Bubble Charts – Part 1
- Article
- 25 Nov 2022
- Liam Bastick
Liam Bastick looks at the Risk Bubble Charts in Excel. This is part one of the article.
Exclusive
TECH NEWS
Traffic cameras - incorporate real traffic lights in your Excel reports
- Article
- 22 Nov 2022
- Simon Hurst
Although the imminent new Excel IMAGE() function provides additional options for displaying pictures that change dynamically based on values in cells, there is already a way to do this using the Excel Camera. The examples in this article show you how to display product pictures and real traffic lights.
Exclusive
EXCEL TIP OF THE WEEK
TECH NEWS
Excel Tips and Tricks #451 – Sparklines Refreshed
- Article
- 05 Aug 2022
- Ian Pay
Hello all and welcome back to the Excel Tip of the Week. This week, we have a Creator post in which we are looking at another under-utilised piece of functionality within Excel – the Sparkline, last covered in TOTW #290.
Exclusive
TECH NEWS
Slicing One Element on a Chart Only
- Article
- 22 Jul 2022
- Liam Bastick
Consider a scenario where create a chart, say, a line chart, but you only want one element (one of the lines) to be modified using a slicer. To illustrate, let’s have some data:
Exclusive
TECH NEWS
EXCEL HOW TO
HOW TO REVIEW A SPREADSHEET
How to review a spreadsheet: Part 3 - analytical review
- Article
- 14 Jul 2022
- John Tennent
In any spreadsheet review you are looking for signals of validity or potential error. A key part of this is a sense check that the numbers ‘look right’. This is supported by using charts (including sparklines), ratios and recalculation.
Exclusive
EXPLORING CHARTS GRAPHS IN EXCEL
Exploring Charts (Graphs) in Excel - Part 12: Controlling zeros or missing data, using conditions to highlight attributes and saving a chart for use in other applications
- Article
- 12 Apr 2022
- John Tennent
For this final blog in the series, we sweep up a few of the more unknown charting features that can add significant value to the display of data.
Exclusive
EXPLORING CHARTS GRAPHS IN EXCEL
Exploring Charts (Graphs) in Excel - Part 11: Adding Trendlines through data series and using the functions
- Article
- 10 Feb 2022
- John Tennant
In previous blogs we have focused upon displaying factual data, in this blog we will explore a few features and functions that assist in predicting future values.
Exclusive
EXCEL TIP OF THE WEEK
TECH NEWS
Excel Tip of the Week #430 - 3D maps
- Article
- 25 Jan 2022
- David Lyford-Tilley
Hello all and welcome back to the Excel Tip of the Week! This week we have a General User post in which we’re going to look at the esoteric and quirky 3D maps feature.
Exclusive
EXPLORING CHARTS GRAPHS IN EXCEL
Exploring Charts (Graphs) in Excel - Part 10: Data series, dual axis, multi-chart overlays and waterfall charts
- Article
- 21 Dec 2021
- John Tennent
In this blog we will explore how to ‘add’ charts together whether they be of different styles (line, bar, area etc.) or with very different scales (dual axis charts). We will finish with a waterfall chart that since 2016 has been available as an Excel chart option.
Exclusive
TECH NEWS
EXPLORING CHARTS GRAPHS IN EXCEL
Exploring Charts (Graphs) in Excel - Part 9: Colours, shadows and graphics (adding clarity not unnecessary use of options), adding backgrounds
- Article
- 12 Oct 2021
- John Tennent
With the plethora of chart options available it is all too easy to get ‘carried away’ and as mentioned in blog 5 there is a balance between medium and message. We also mentioned that in a pole of FDs that were asked to vote on their least favourite Excel feature, it was 3-D charts that topped the list. In the words of A.S.C. Ehrenberg “a Chart is a means of making results clear and memorable” and thus clarity is the primary objective
Displaying 1-20 of 77 results
Search the Excel Community archive
This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.