This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a column chart in Excel containing 3 series of data. I am trying to leave one of them stand alone to show 2016 numbers & overlap the other two to show actual numbers vs projected numbers. When I use the secondary axis, it makes it overlap both the other column charts. Is there a way to make it only overlap the one?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
You will need to add extra data series to act as place holders.
In effect 3 series on primary axis, Actual , Projected, Dummy.
and 3 on secondary axis, Dummy , Dummy, 2016 data.
Additional legend entries can be deleted.
In such type of questions, a screen-shot shared of current situation and a drawing of desired output helps us a lot .
Just guessing / imagining your problem and then proposing a suitable solution may not always help.
Can you pls share some screen-shots (with examples) pls ?.