Forum Discussion
How to Make a Combination Chart with Line on Secondary Axis
Ok great! So it looks like the problem was you had duplicate dates, and excel freaks out when there are multiple x axis and y axis coordinates. I slimmed your data down to just one date and one projected/actual count, and charted those.
You can change the numbers and dates as needed but this should give you a good template to work off of.
Let me know if this helps.
Thanks for your help. I feel like I am so close and yet so far. I am trying to get a sheet where I can show progress over the next few months. I would like to be showing the actual count on one axis and percent complete on the secondary of harvesting the data off of 1700 drawings. Every couple weeks I am going to enter the current progress and those will be bars, and the theoretical steady progress line will be there to show we are on pace or not.
Ok great! So it looks like the problem was you had duplicate dates, and excel freaks out when there are multiple x axis and y axis coordinates. I slimmed your data down to just one date and one projected/actual count, and charted those.
You can change the numbers and dates as needed but this should give you a good template to work off of.
Let me know if this helps.
I need help on something similar. I can get two vertical axes to show, but I cannot get the line to show that represents the second vertical axis. Contrary to the example you show, my left and right data are not related. I am puzzled by your comment that a problem might be duplicate dates. You said you slimmed the data down to one set of dates; but when I go into your example, I do see that each data set displayed uses the same set of dates; isn't that then two sets of dates? Is it that the dates are identical that resolved the issue? In my case, I also cite just one set of dates for my horizontal axis labels, but still my secondary line does not show.
