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.
Having 3 columns might be the problem, try switching the axis's by selecting you data > pressing insert chart (type doesn't matter now). I just did a line graph.
Then right click the graph > select data
And in the box that pops up, press switch row/column.
Let me know if that fixes it. Excel is really good about creating graphs for you, there isn't much manual work required outside of getting the data formatted in a way that it reads it correctly.
