Jun 24 2021 11:19 AM
I used to be able to graph anything on Excel, but it seems like they have taken away all my control and put together wizards that don't work, if I don't have things formatted just the way Excel wants. I need some help understanding how to make this Wizard happy. When I try to choose Change Chart Type to Combo with Line on Secondary Axis, it is greyed out and will not let me choose it.
Jun 24 2021 11:33 AM
Is your data formatted correctly? You'll need at least 3 rows, your x-axis, and values for each line like so:
From there, all you have to do is click insert chart > Combo > and click the Secondary axis button on whichever data set you want on that axis and change both chart types to line.
Jun 24 2021 11:44 AM
Jun 24 2021 12:05 PM
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.
Jun 24 2021 12:42 PM
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 %.
Jun 24 2021 01:52 PM
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..
Jun 24 2021 02:33 PM
Jun 25 2021 07:02 AM
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.
Jun 25 2021 09:05 AM - edited Jun 25 2021 09:59 AM
SolutionOk 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.
Jun 25 2021 09:05 AM - edited Jun 25 2021 09:59 AM
SolutionOk 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.