+ Reply to Thread
Results 1 to 1 of 1

Why does my "Close" data not display on one chart but does on another?

  1. #1
    Registered User
    Join Date
    03-22-2021
    Location
    Kokomo, Indiana
    MS-Off Ver
    365
    Posts
    6

    Why does my "Close" data not display on one chart but does on another?

    Hello - on the same stock spreadsheet where I have the "volume" being plotted as a line rather than a bar issue, I've found another (seemingly unrelated) question. I notice in my iterations of working with this chart that I've lost the ability to plot my "Close" price whereas earlier revisions of my spreadsheet graphed it correctly. I copied the "bad" chart as a separate worksheet in my sample spreadsheet I'm attaching here.

    1. I make named ranges and then plot them in a chart using "Select Data"
    2. The named ranges are Date, Open, High, Low, Close, Volume
    3. In the good chart, Date, Open, High, Low, Close are plotted properly. (notice the hollow candlesticks)
    4. In the bad chart, Close is not being graphed. (there are no hollow candlesticks)
    5. I see no difference between the good and bad charts when I right click on the chart and choose "Change Chart Type". They're both "Combo-Custom Combination". I do find it odd that each series is blank under chart type, but whatever...
    6. When I right click on the chart and choose "Format Plot Area", and then in the dropdown from Plot Area Options, I see a difference in the series Close.
    On the good chart, when I click on the 3 column icon titled "Series Options" it comes up with an option for Gap Width indicating that this Close series is a bar (column) type.
    On the bad chart, when I click on the 3 column icon titled "Series Options" I don't get that Gap Width option, indicating this Close series is not a bar (column) type.
    7. There is only 1 "Close" data range defined (under Formulas > Name Manager)

    I know #6 is the crux of my problem, but why is the Close series not being identified as a bar graph type on the bad chart and it is on the good chart?

    8. I'm only able to display "Volume" as a line graph but I want to display it as a bar graph - but that's a separate question I asked yesterday.

    Thanks for any help!
    Attached Files Attached Files

+ 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: 0
    Last Post: 05-30-2017, 04:48 PM
  2. Replies: 1
    Last Post: 08-20-2016, 01:59 AM
  3. Replies: 0
    Last Post: 11-22-2013, 01:36 PM
  4. Replies: 2
    Last Post: 06-25-2013, 12:43 PM
  5. [SOLVED] Excel Stock Chart - "Close marker" refers to incorrect data series
    By MartinShort in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-07-2012, 10:50 AM
  6. Pie Chart - Display Groups of data as "Other"
    By TurboH in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-24-2012, 08:07 AM
  7. Replies: 4
    Last Post: 02-03-2008, 05:11 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