I need help!! i dont know how to make the secondary axis look like the left chart! I need the points to be without the line that joins them and to see the percentage.
graphs.png
1.png
2.png
I need help!! i dont know how to make the secondary axis look like the left chart! I need the points to be without the line that joins them and to see the percentage.
graphs.png
1.png
2.png
It is not clear to me what you are stuck on. Here's how I would expect to do this:
1) Create pivot chart as column chart
2) Change the chart type of the desired series to "line with markers" (since I assume that "line with markers but no line" is still not a valid chart type).
3) Format each line series to get rid of the line and move to the secondary axis.
4) Add data labels to each line series.
5) Format labels to include the Y value (if Excel chooses something else when the data labels were added).
Which step do you get stuck on?
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks