There’s no standard chart design within Excel to accommodate this, which meant I had to come up with a workaround. It’s easy enough to create a dual-axis chart in Excel, if you want the bars side by side. Well, I really didn’t HAVE to create the chart in Excel, but others needed to be able to update the chart and they, gasp, don’t have a Tableau license. Tableau makes this task incredibly easy, but I needed to do this in Excel. I needed to create a dual-axis chart, with two bars on the primary axis and a line on the secondary axis. I came across a challenge last week while working on a project.
