Charting question about "# of categories between tickmarks"

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,750
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
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

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".
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,517
Messages
5,832,223
Members
430,116
Latest member
d1pakjha

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