+ Reply to Thread
Results 1 to 2 of 2

Please help me add a secondary ordinate axis to scatter chart

  1. #1
    Registered User
    Join Date
    01-24-2020
    Location
    Just behind that tree
    MS-Off Ver
    2013
    Posts
    8

    Question Please help me add a secondary ordinate axis to scatter chart

    Hiya people! I had a thought that it would be nice if I could add an ordinate axis with temperature to some concentration against time charts. Using a popular search engine, I found some workarounds (which I did not all totally understand) using a line from a set of data made to look like an axis using a scaling factor, and placing two charts over each other to look like one.

    Furthermore, I found a fairly straightforward way of adding a third axis to a line or bar chart using the combo chart. However, that does not seem to be a good fit with my data (temperature, time and concentration).

    Can any of you point me to something that I have missed?
    Last edited by QuieT; 05-11-2020 at 08:20 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,456

    Re: Please help me add a secondary ordinate axis to scatter chart

    you probably can just add the second series, in it's properties select displaying on secondary axis, and finally make sure all axes you need are visible (by default excel do show only secondary vertical (but not horizontal) axis in: Chart Design -> Add chart element

    If this hint is not enough, see next hint in a yellow banner near the top of the page.
    Best Regards,

    Kaper

+ 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. Replies: 7
    Last Post: 05-11-2020, 07:37 AM
  2. Replies: 5
    Last Post: 05-03-2020, 06:01 AM
  3. [SOLVED] Primary Axis & secondary Axis have high gap to show in chart
    By leakhna in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-05-2018, 02:19 AM
  4. Replies: 2
    Last Post: 08-12-2005, 08:05 AM
  5. XY scatter and Bar chart - secondary axis misaligned
    By philcud in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-08-2005, 04:05 AM
  6. XY scatter and Bar chart - secondary axis misaligned
    By philcud in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-03-2005, 11:05 AM
  7. [SOLVED] Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis
    By mw210461@yahoo.com in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-13-2005, 05:05 PM

Tags for this Thread

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