+ Reply to Thread
Results 1 to 5 of 5

Stock chart, format the line

  1. #1
    Registered User
    Join Date
    12-24-2016
    Location
    Germany
    MS-Off Ver
    Microsoft office 2013
    Posts
    55

    Stock chart, format the line

    Hi community,

    I have created my stock chart. No I am trying to replace the green line (you will see in my attachment) with dots, but I fail to do it. The thing is, I don't want "Fourth" series to be depicted by a line, rather dots.

    Any suggestions?
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Stock chart, format the line

    Hi,

    Right click on the green series line, or select it from the Chart Tools Layout menu, choose Format Data series and pick the Line Style - Dash Type and select the round dots option.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-24-2016
    Location
    Germany
    MS-Off Ver
    Microsoft office 2013
    Posts
    55

    Re: Stock chart, format the line

    My bad. I did not explain it accurately. Sorry.

    I want the series to be depicted my dots (I want to use a Scatter). Here is an example.
    Attached Files Attached Files

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

    Re: Stock chart, format the line

    Same basic answer -- Right click on the green series line, or select it from the chart tools layout menu, choose format data series, and format as desired -- in this case, it sounds like you want no line (which is cleverly hidden in the "line color" tab) and add the desired marker style from the marker options tab.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Registered User
    Join Date
    12-24-2016
    Location
    Germany
    MS-Off Ver
    Microsoft office 2013
    Posts
    55

    Re: Stock chart, format the line

    Cheers MrShorty!!! Somehow I did not notice it. Thanks a lot!!!

  6. #6
    Registered User
    Join Date
    12-24-2016
    Location
    Germany
    MS-Off Ver
    Microsoft office 2013
    Posts
    55

    Re: Stock chart, format the line

    Thanks Richard!!!

+ 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. How to add DowJones Line Chart on to Yahoo Stock Chart
    By HerryMarkowitz in forum Excel Charting & Pivots
    Replies: 24
    Last Post: 02-10-2015, 05:49 PM
  2. Add Horizontal line to stock chart
    By 4dplane in forum Excel General
    Replies: 6
    Last Post: 12-19-2012, 08:51 PM
  3. Stock chart - combo of line and bar chart
    By cw56 in forum Excel General
    Replies: 2
    Last Post: 11-15-2010, 06:19 AM
  4. Line Chart (Stock Intraday Chart)
    By prabs in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-25-2007, 06:19 PM
  5. Vertical line in stock chart
    By wittmaennle in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-21-2006, 11:10 PM
  6. Adding a horizontal line to a stock chart
    By wittmaennle in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-21-2006, 03:20 AM
  7. [SOLVED] How to add a line to a stock chart
    By Kingshuk in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-19-2005, 09:06 AM

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