Displaying 1-20 of 74 results
Exclusive
Advanced conditional formatting – part 2: the highlights
- Article
- 21 Sep 2023
- Simon Hurst
After looking in part 1 at some of the more advanced ways to use cell formats as part of conditional formatting, in this episode, we are looking in depth at the graphical conditional formats.
NEW TECH FEATURES
Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: 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 #478 - Introduction to Power Automate
- Article
- 05 Sep 2023
- Thomas Edmunds
Hello and welcome back to Excel Tips and Tricks! This week we have a Developer level post where we will demonstrate how to use Power Automate to run an Office Script against multiple Excel files simultaneously.
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
'Why Power Query can change your life' - webinar recording now available
- Article
- 13 Mar 2023
- Simon Hurst
Simon Hurst yet again claims that Power Query can change your life and attempts to prove it in a live webinar. This is the first of two posts dealing with the questions that the webinar provoked.
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
Exclusive
TECH NEWS
EXPLORING CHARTS GRAPHS IN EXCEL
Exploring Charts (Graphs) in Excel - Part 8: Best practice in layout and recycling charts
- Article
- 11 Aug 2021
- John Tennent
So far in the blog series we have focused on the main chart attributes. In this blog we look at the other elements around the edges - titles, labels, legends, axis crossing, gridlines and tick marks. We will also illustrate how to recycle charts with alternative data sets.
Exclusive
TECH NEWS
Multiple Sparklines in a single cell
- Article
- 06 Aug 2021
- Simon Hurst
I was asked recently how to combine two different Sparkline charts in a single cell. This was one of those occasions when, although I came up with an answer that seemed to work, I couldn't help wondering whether there was an easier and better way.
Exclusive
TECH NEWS
Data visualisation – small multiples
- Article
- 07 Jul 2021
- Simon Hurst
With the introduction of many new chart types in Excel 2016 and later versions, Excel now has over a dozen main charts with lots of sub-types available. Good as Excel's charting capabilities might be, using Power BI to present the data from your Excel workbook opens up a whole new set of possibilities
Displaying 1-20 of 74 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.