Charting question about "# of categories between tickmarks"

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,749
Hi all,

I have a chart (line graph) that shows 12-month results trend. I formatted the X-axis so that the number of categories between tick marks is 2.

I noticed that when excel assigns tickmarks, it counts the first category as 0. So now that I chose to have 2 categories between tick marks, the tick marks fall on the 3rd, 5th, 7th, 9th and 11th month of my 12-month trend line graph.

Is there a way to force excel assign the tick marks on the 2nd, 4th, 6th, 8th, 10th and 12th month instead?

Thanks
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Derek Brown

Well-known Member
Joined
Dec 26, 2005
Messages
2,390
Probably not an ideal solution but I would consider having a 'blank' category at the beginning and end of my data.
For example I would have January in A3 through to December in A14 with the values in B3:B14 etc.
The chart X-Values would then be A2:A15 and the chart Values would be B2:B15. I would also untick the "Value (Y) axis crosses between Categories".
 

Watch MrExcel Video

Forum statistics

Threads
1,122,569
Messages
5,596,915
Members
414,110
Latest member
docops

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
Top