line chart inserts unwanted dates

PARans

Board Regular
Joined
May 24, 2007
Messages
181
Hi, I have a line chart where the x axis is a date. The source values in the corresponding table include date in the first column with the data point value in the second column. There are only dates and corresponding values for the weekday dates. Although no weekend dates are shown in the table, the x axis displays the weekend dates and the line stretches across the weekend dates to connect the Friday's data point to the Monday data point.

I can not figure out how to eliminate these dates so the axis shows the Friday date immediately follwed by the Monday date just as it is in the table.

thanks for your help.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Select the chart, right click and select Chart Options, and on the Axes tab change the Primary Axis button to Category.
 
Upvote 0

Forum statistics

Threads
1,213,530
Messages
6,114,162
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top