Help with charts!!

buteaur

Board Regular
Joined
Mar 15, 2016
Messages
170
I never use Excel to create graphs/charts.

I was asked to do one today and I'm having an issue.

the data is weekly but the horizontal access should be monthly. It's showing the weeks which of course makes it look terrible. In fact the dates don't line up with the data.

Help!
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Thank you. I don't show that option for calling out months when I choose, "format axis". I'll troubleshoot but thank you for the article. Very helpful.
 
Upvote 0
In the screenshot below, there are weekly dates and corresponding data. I made a line chart, and Excel automatically made a date axis, with a spacing of seven days. Reasonable enough, but a monthly axis might look better.

YGrHL3y.png


Below, I've changed a few settings in the Format Axis task pane. I changed the major unit to 1 month. (I did not change the base unit to months the way that Microsoft article did, because it would plot all April points in a vertical line at April and all May points in another vertical line at May.) I also set the minimum to April 1 instead of 2 and the maximum to June 1 instead of May 28.

Ix6eBue.png
 
Upvote 0

Forum statistics

Threads
1,213,486
Messages
6,113,932
Members
448,533
Latest member
thietbibeboiwasaco

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