combination chart

I've created a combination scatter and stacked column chart in Excel 365. The scatter chart is used to show red, amber or green circles and the labels - one series for each colour and another for the label. The label contents are sourced from a range of cells. The column chart creates the...

Hello, Looking for a formula to generate all possible UNIQUE combination of the contents of 3 rows. I want to avoid results with the same content in different positions (such as aac, caa, aca should be appear only once, regardless of which) Row1 Row2 Row3 a a a b b...

I have a waterfall chart (for no reason other than I thought it would be different) with costs up one side for various dates along the other. This works, I've got this bit sorted, pretty confident at the selecting of cells. What I want to have is another set of data that isn't the same size...

I have built a combo graph which plots shop load (in vertical bars) and shop capacity (in a line), and I want to represent the average shop load in a straight horizontal line. Sometimes the simplest tasks can create the biggest headaches, right? I am finding that simply adding an additional line...

Hi, I have two charts. The first one is a waterfall chart with bars for for sales opportunities and their stages of completion.i.e the x-axis will have the % to completion at which the deal currently stands at such as 90%, 70% etc. and the y-axis refers to the amount of the deal. The second...

Hello, I'm in the process of expanding on a macro to look at customer ID and the product name they ordered. If they ordered a set of a particular product then it will combine both product name into one and delete the oldest record. I have created another tab that combines the product...

Hello, I have a stacked Area chart in a combo chart with cluster columns. The stacked area chart utilizes the secondary vertical axis. The sides of the area chart end in the middle of the label on the horizontal axis (centered on the tick mark and the cluster columns). If I change the Axis...

Hi all, I have created a combination chart in excel - my bar chart covers 3 years and I'd like to show the growth rate as a line chart on top of those. Is there a way to limit the line chart to just the outer two years? When I alter the data selection to only include the growth rate for 2 of...