How can I make data skip over certain dates (ex weekend) Example included.

appplejack007 · #1 06-11-2020, 02:07 PM

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!

ArviLaanemets · #2 06-11-2020, 11:26 PM

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).

appplejack007 · #3 06-12-2020, 02:33 PM

Thanks I solved it.

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