![how to plot a graph in excel based on date how to plot a graph in excel based on date](https://www.exceldashboardtemplates.com/wp-content/uploads/2012/05/image43.png)
- #How to plot a graph in excel based on date how to
- #How to plot a graph in excel based on date full
- #How to plot a graph in excel based on date professional
- #How to plot a graph in excel based on date series
The default line chart in Excel has no data point markers. These changes make the y-axis much easier to read: Under Display Units, choose to group the data by “Thousands”. Since our chart data ranges from 0 to $1m, it is probably safe to use $250k increments. In the Format Axis dialog under the Axis Options, change the Major Unit from Auto to Fixed. We can ask Excel to show fewer lines and abbreviate the dollar values to make it easier to read.ĭouble-click one of the dollar values on the y-axis to bring up the Format Axis dialog.
#How to plot a graph in excel based on date full
In the default view, the full thousands of dollars are shown, and there are too many lines crowding up the graph. The y-axis can also use some cleaning up. Under Axis Options, change Position Axis to On Tick Marks. Line charts (especially line charts with shaded areas – see the last section of the tutorial) often look better without these margins:ĭouble-click the date axis to bring up the Format Axis dialog. The default line chart in Excel adds margins before the first data point and after the last data point. The new x-axis will be much cleaner to look at: To learn about other date formats, you can check out the Definitive Guide Custom Number Formats in Excel. In the Format Cells dialog, choose the Custom category, and in the Type field, type “mmmmm”. In the Format menu of the Home tab, click the arrow in the lower right to bring up the Format Cells dialog. To format the date axis, select the date cells from the original data table. It is possible to just show the number of the month, but it can sometimes be clearer to use the first letter of the month. The year will probably be shown in the chart title, so we only really need to see the month. This chart only shows monthly data, so it doesn’t help to provide the day. When working with dates on an axis, it is often difficult to read the timeline. When it is selected as seen below, press the Del key to remove the legend from the graph. Select the legend by clicking on the text or line graphic. Since it’s not needed, let’s go ahead and delete the legend. If the chart is titled “Sales” and there is only one line, the user doesn’t need to be told again that the line represents sales figures. When you are working with a single data series, there is no confusion about what data is being presented. Small Tweaks and Improvements Removing the Legend Let’s see what we can do to make it look more professional. It isn’t very pretty, but it would get the job done.
#How to plot a graph in excel based on date series
Start by selecting your basic data table with the series name on the left and the dates (or labels) in the top row.įrom the Chart menu on the Insert tab, choose the Line drop-down and choose the first option. It may not have the polish we want, but Excel’s basic line chart is a great starting point for our cool new version.
#How to plot a graph in excel based on date how to
Here’s how to make a better line chart in Excel… The Default Line Chart These touches can give the boring old graphs a fancy new look. Even a basic line chart can be given a cool makeover with better colors, axes, and shaded background to make it stand out.
![how to plot a graph in excel based on date how to plot a graph in excel based on date](https://i.stack.imgur.com/MCj7r.png)
![how to plot a graph in excel based on date how to plot a graph in excel based on date](https://howafrica.com/wp-content/uploads/2016/06/Excel.jpg)
To make your presentation, website, or sales pitch really make a good impression, you’ll want to find a way to improve on the default charts.
#How to plot a graph in excel based on date professional
They are functional, but they don’t give a very professional look to your data.