How To Make Tick Marks Thicker In Excel
03-07-2014,12:02 PM #i
Registered User
How to have the year label center and bigger tick marks at the beging/end of each year
Hi,I want to plot a monthly data series and on the x centrality I would like to have year labels center.
I need to have tick marks at the terminate of each quarters (mar, jun, sep and dec) (pocket-size tick marks). I need to have bigger tick marks (major tick marks) at the beginning of each year.I accept attached to the spreadsheet that show the closest I can get to my goal but I am missing the major tick marks at the beginning of each twelvemonth. Colums A and B show where I would like to have the tick marks.
Every calendar month I accept new data and I drop sometime data.
Whatsoever advice would be helpful.testaxis.xlsx
katerine
03-07-2014,12:35 PM #2
Re: How to have the year characterization eye and bigger tick marks at the beging/end of each year
Given the amount of information and pretty as spacing of the fourth dimension slots I would become with the just multi category approach.
03-11-2014,x:11 AM #3
Registered User
Re: How to have the year label centre and bigger tick marks at the beging/stop of each year
Thank you very much for your reply! Is in that location a way to have smaller tick marks instead of these big bars? Also I tried to remove the month labels but it did not work. I but want to display the yr.
I was given a graph that was created with a different application and I have to reproduce exactly the aforementioned graph in Excel.Thanks for your help,
katerine
03-xi-2014,x:48 AM #four
Re: How to have the year label center and bigger tick marks at the beging/end of each year
If you format the axis line to None the tick marks volition be removedtin yous post an case/picture of the chart you are trying to create.
03-xi-2014,11:16 AM #5
Registered User
Re: How to have the year label center and bigger tick marks at the beging/end of each year
chart09_5.pdfAttached is an example of what I am trying to achieve.
03-11-2014,12:12 PM #6
Re: How to have the year label center and bigger tick marks at the beging/end of each year
You lot are probably best off created the tickmarks and labelling your cocky using a dummy serieshttp://peltiertech.com/Excel/Charts/ArbitraryAxis.html
03-12-2014,09:55 AM #7
Registered User
Re: How to have the year label center and bigger tick marks at the beging/end of each twelvemonth
This link was really useful thank you.
It is almost perfect now but I have result with the marker.I need the tick marks inside the graph but when I set the marking to + sign the tick marks are crossing the x-axis. I tried to employ a elementary vertical bar or a T (upside down) but because Excel center the markers I can't get the tick marks within the graph.
03-12-2014,x:05 AM #eight
Re: How to have the year label middle and bigger tick marks at the beging/end of each year
Rather than markers try using Y error bars.Change the Y value from 0 to five (for example). The add together error confined, setting Y error bars to 100% minus no cap.
Delete ten error bars.
03-17-2014,03:00 PM #9
Registered User
Re: How to take the yr label heart and bigger tick marks at the beging/stop of each yr
Howdy,
Cheers for your reply. I don't think this solution will work in my context because the data will be ever irresolute and therefor the y-centrality volition be changing. If I set the dummy series to 5 today, this value might be also small-scale or too big next time. The workbook I am creating will exist used to create a publication and each time the user refresh the workbook the graphs must exist fine without whatsoever manual fixes needed.
katerine
03-eighteen-2014,04:34 AM #10
Re: How to accept the year label center and bigger tick marks at the beging/terminate of each year
You could ever utilise a formula to summate a value that is a percentage of the plot area. So use Custom Error bar values to arrive dynamic
Source: https://www.excelforum.com/excel-charting-and-pivots/994839-how-to-have-the-year-label-center-and-bigger-tick-marks-at-the-beging-end-of-each-year.html
Posted by: ortegoounge1939.blogspot.com
0 Response to "How To Make Tick Marks Thicker In Excel"
Post a Comment