|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I make data skip over certain dates (ex weekend) Example included.
I've been a market participant for few years and I started experimenting with making my own charts with excel. I have a workbook and a screenshot attached to it. Basically, I have a series of data. I got it from Yahoo Finance by downloading historical data. From Jun 4,2020, I started manually adding data instead of downloading the new ones everyday from Yahoo Finance. The chart in the work book is what I created. As you can see there's a weekend Jun 6,7 and the chart include their data as zero. So, how can I skip over dates (weekends)? Thanks! |
#2
|
|||
|
|||
Your problem in not weekend. You have entered Volume values as numbers and formatted the column to display them with comma as thousands delimiter. But for date 6/9/220 (with btw. is not weekend date, it is Tuesday!) instead number 35046300 you entered a text '35,046,30[0]'. For graph, Excel interprets it as 0 (any text in numeric column has numeric value 0).
|
#3
|
|||
|
|||
Thanks I solved it.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Skip to next row after data is entered | pollofeliz32 | Excel | 1 | 04-26-2019 05:49 AM |
Date Axis on line chart includes dates with no data under them, but text axis causes data to clump | jcyo233 | Excel | 6 | 10-18-2018 04:49 AM |
How do I make a simple graph with a list of dates at the bottom? | MRnightmuffin | Excel | 1 | 01-18-2018 06:48 PM |
Embedded Excel charts refresh only data values, not which data points (rows) are included | GregL | Word | 0 | 12-01-2016 10:24 AM |
How do I make a checkbox or dropdown item reference data in that specific section of the data array? | dhare | Excel Programming | 2 | 02-24-2016 12:36 PM |