how to plot a graph in excel based on date

Now, select the “Dot” and choose the “Marker Option” to make this a delta shapes marker with black color.

Select “Dot” data labels and make this data label “Values From Cells.” For example, choose values from A2 to A9.

For “Axis label range,” choose an “Estimated Date.”.

For example, in the below window, choose “Helper” and click on the “Edit” option.

Select the chart and click the “Select Data” option.

From the formatting window, select “Category Name.”

Selecting data labels, press “Ctrl + 1” to open the formatting window.

Now, delete the “Secondary Axis” vertical values.Select the horizontal flat line chart and make this a “Secondary Axis.”.Click on “Error Bar Options,” select direction as “Minus,” and “Error amount percentage” as “100%.”.As soon as you click on “More Error Bars Options,” it will open up a formatting option to the right side again.Under “Add Chart Elements,” go to “Error Bars” in Excel and choose “More Error Bars Options.”.Then, under the “Design” tab, go to “Add Chart Elements.” Click on the “Design” tab with the same selection.Then, under the “Line” option, select the “No line” option. Now, click on the line chart and press the shortcut key “Ctrl + 1” to open the “Format Data Series” option to the right of the chart. After all this, we need to do some formatting touches.Now, in the next window, enter “Helper” for “Series name,” and for “Series values,” choose helper column values.Click on “OK.” Now, click the “Add” button in the same window again.In the below selection window, choose date values.Now, click on “OK.” Then, in the same window, click on the “Edit” option on the right-hand side, “Horizontal (Category) Axis Labels.”.In the below window for “Series Name”, enter “Date”, and for “Series Values”, select task list.In the below window, remove the legend entries.

Now, right-click on the chart and choose the “Select Data” option.

Select the data, go to the “INSERT” tab, and insert an Excel “Line with Markers.”.

Insert a helper column and insert the number 10 with one positive number and one negative number.

The first thing we need to do is to create a modified data table.

How to plot a graph in excel based on date