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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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