Bar with average line chart for Excel. Download Overview of bar with average line chart for Excel In many businesses, the bar chart is very common. However, you may not see an average line with these charts. But, financial firms may use this chart often. Therefore, it you will want to have this chart in […]
This how-to quick snapshot video shows you examples of using For Next statement for basic counting in Excel VBA. Remember, this snapshot is not a full tutorial. How to show basic counting using For Next statement We use Debug.Print to show results of different ways to count numbers from zero to ten. Debug.Print is a […]
This quick how-to snapshot shows you basic Excel operators that you use in spreadsheet development and analysis. Please pay attention to the table and not the chart holder. Overview of basic Excel operators So, the main operators to use in spreadsheets are: assignment, addition, subtraction, multiplication, division, power, and concatenation. Keep in mind, we are […]
So, the Blank Excel Template (or BET) is a tool we use when we create different types of spreadsheet documents. Overall, it is a great, basic template. Therefore, we made the decision to share this tool with our users. Overview of the Blank Excel Template Once you download BET, there is no one way to […]
The Blank navbar template for Excel is very similar to our Blank Excel template. However, this particularly template has a navigation bar and a cover page. Overview of blank navbar template Again, this template is almost exactly the same as our blank Excel template. This one though, has a cover page, navigation bar, and six […]
The bubble chart with trend line. Download The bubble chart with trend line In the past, bubble charts got on my first and last nerve. Perhaps, it was due to the kind of bubble graphs that I had to work with. Mostly, these graphs had like hundreds of bubbles in it. Moreover, each time someone […]
This quick video tip shows you how to change cells from night to day in Excel. Change cells from night to day in Excel In this instance, we use a macro to accomplish this task. So, what we do is record the process of selecting all the cells in the sheet. Then, we change the […]
This quick snapshot shows you how to change chart x-axis number format. Snapshot to change chart x-axis number format Below is the snapshot card showing you how to change millions to thousands, without modifying any data on the spreadsheet. Everything is done on the chart, retaing the data. Excel is the main vehicle for this […]
Chart Switcher for Excel The Chart Switcher is a tool for Excel 2003. Originally, it was an experiment to see if we can update the source of a chart from a user’s selection. We plan to keep it in the experiment category, as a vintage tool. If you click in cell B6, then a dropdown […]
Basic ChatGPT Excel quiz. Excel Effects wanted to try out the functionality of this popular AI tool. So, we had the AI create a basic quiz on Excel. Well, we think it is fairly basic. Also, we thought the AI was pretty impressive. However, there was one minor issue and one error. Minor issue: Four […]
The clustered column chart. Download Overview of the clustered column chart The clustered column chart is perhaps the most widely used chart in business. In general, it has a basic appearance. However, you get an excellent visual of your data in a very simple form. Some like to compare this graph to a pie chart […]
Clustered column chart with scatter chart for Excel The clustered column chart with scatter chart definitely a special combination chart. Requirements Microsoft Excel 2007 or higher or compatible. Download Chart library
