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.
Can you tell me step by step like I haven't been making charts for 28 years? Cuz this is hard to swallow that I suddenly can't make a chart. Thanks.
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.
It helps seeing your data, I recreated a small piece of your data and ended up with something that looks like this:
With chart type set up like this:
To summarize, I selected the data, inserted chart (doesnt matter what type), changed chart type to combo, made both series into lines, and clicked secondary axis for the %.
It seems to be hopeless. I cannot get my graph to look like I want.
This is closer to what I need it to look like. Number of tasks done on Y axis vs. Dates on X axis. The actual progress in bar form and a line showing the targeted progress from start to the finish of the project..