+ Reply to Thread
Results 1 to 2 of 2

putting separators in the chart

  1. #1
    Registered User
    Join Date
    01-08-2021
    Location
    kuwait
    MS-Off Ver
    365
    Posts
    2

    putting separators in the chart

    WhatsApp Image 2021-01-08 at 00.23.26.jpegWhatsApp Image 2021-01-08 at 16.11.32.jpeg

    kindly how can i insert the separators in my chart like the picture
    thanks
    Whats-App-Image-2021-01-08-at-16-11-32 — ImgBB


    Whats-App-Image-2021-01-08-at-00-23-26 — ImgBB

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

    Re: putting separators in the chart

    If I understand what you are trying to do, Excel does not have a "built in" option for adding these lines. However, you can add them yourself in various ways -- depending on chart type:

    The first picture looks like a scatter chart. Adding a line to a scatter chart is as easy as adding another data series to the chart made up of one point with error bars or made up of two points connected by a line.

    The second, hand-drawn picture looks like a column or bar chart. Adding lines to a column/bar chart is similar -- add another data series and change to XY scatter chart type (effectively creating a column/bar + XY scatter combination chart), then use the XY scatter data series to provide the lines.

    Look over this tutorial and see how far you get: https://peltiertech.com/Excel/Charts/AddLine.html
    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. Putting specific data into a chart
    By Overdahill in forum Excel General
    Replies: 4
    Last Post: 08-17-2017, 06:48 AM
  2. putting a percentage calculation into a chart
    By LLOYD6664 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-18-2016, 08:18 PM
  3. [SOLVED] excel chart multi level axis remove separators
    By Vladimir.Yanakiev in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-18-2016, 05:34 AM
  4. Putting two charts in one chart
    By nagesh.tvsr in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-02-2015, 11:24 PM
  5. putting a chart and two graphs onto a new sheet
    By aholland in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2011, 12:18 AM
  6. Putting two sets of data on one chart
    By glitterstorm in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-31-2007, 12:26 PM
  7. [SOLVED] I need separators on the X axis of a chart.
    By Frank Martin in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-03-2006, 08:35 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