Two most commonly asked or searched queries when it comes to charting are,
- How to combine two chart types in one chart, like a line chart combined with bar chart?
- How to add a secondary axis to the chart so that one or more data series are plotted on the secondary axis?
Excel combination charts are a great way to combine two chart types in to one.
Using data series options you can plot a particular series on secondary axis.
In this quick video tutorial you can learn how to make a combination chart and add secondary axis in less than 15 seconds.
Watch it on youtube: Creating combination charts and adding secondary axis – video tutorial
9 Responses
Thanks for this one!
How do i create a chart that has negative numbers on axis x and y and plot them correctly? I cannot seem to understand how to do this, please help.
Thanks.
Nat
You can also plot 2 or more Y axes in Excel using EZplot or Multy_Y from Office Expander.com
There is a demo version to try.
Cheers.
Hi Chandoo,
Fantastic Challenge. Thank You ??
My answer to Q.2 is 48 . . NOT 49.
A.1)
LET(emp, ISNUMBER(XMATCH(trainings[EMP ID], staff[EMP ID])),
trng, ISNUMBER(XMATCH(trainings[COURSE ID], {“CM101″,”CC101″,”EAT101”})),
comp, trainings[PASS/FAIL] = “Pass”,
a, GROUPBY(trainings[EMP ID], emp * trng * comp, SUM, , 0, , emp),
result, SUM(–(CHOOSECOLS(a, 2) = 3)),
result)
A.2)
LET(emp, ISNUMBER(XMATCH(trainings[EMP ID], staff[EMP ID])),
trng, ISNUMBER(XMATCH(trainings[COURSE ID], {“CM101″,”CC101″,”EAT101”})),
comp, trainings[PASS/FAIL] = “Pass”,
a, GROUPBY(trainings[EMP ID], emp * trng * comp, SUM, , 0, , emp),
result, SUM(–(CHOOSECOLS(a, 2) >= 1)),
result)
A.3)
SUM(–(NOT(ISNUMBER(XMATCH(staff[EMP ID], trainings[EMP ID])))))
Best Wishes!