+ Reply to Thread
Results 1 to 2 of 2

Need help on pivot chart on secondary axis

  1. #1
    Registered User
    Join Date
    03-30-2017
    Location
    United States
    MS-Off Ver
    10
    Posts
    1

    Need help on pivot chart on secondary axis

    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

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Need help on pivot chart on secondary axis

    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?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Primary and Secondary axis on pivot chart
    By sabha in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-13-2017, 01:29 PM
  2. Secondary Axis On Pivot Chart
    By doakra in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-21-2015, 10:37 AM
  3. Set a value from pivot to secondary axis in a chart
    By Bandini in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-30-2014, 04:04 AM
  4. Trouble using the secondary axis with a pivot chart
    By msantucci in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-13-2014, 09:42 AM
  5. Replies: 0
    Last Post: 07-13-2005, 05:05 PM
  6. [SOLVED] Perserving secondary axis in pivot chart
    By David in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-28-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1