Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
x axis tick marks
How do I add tick marks on the x axis for irregular time periods. Each
period may have only 5 points of data or 12 points. The name of each period needs to be between the tick marks to indicate the exact time period. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
x axis tick marks
Buckeye5
You can use an XY chart with a custom X axis, aka dummy axis series. Here's a link to a tutorial on custom axes. I have a number of examples on my site. http://processtrends.com/pg_charts_custom_axis.htm Kelly O'Day http://processtrends.com "Buckeye5" wrote in message ... How do I add tick marks on the x axis for irregular time periods. Each period may have only 5 points of data or 12 points. The name of each period needs to be between the tick marks to indicate the exact time period. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
x axis tick marks
When I remove the original x axis I don't know how to add in the custom x
axis. The labels for the axis are quarters in a year. Thanks "Kelly O'Day" wrote: Buckeye5 You can use an XY chart with a custom X axis, aka dummy axis series. Here's a link to a tutorial on custom axes. I have a number of examples on my site. http://processtrends.com/pg_charts_custom_axis.htm Kelly O'Day http://processtrends.com "Buckeye5" wrote in message ... How do I add tick marks on the x axis for irregular time periods. Each period may have only 5 points of data or 12 points. The name of each period needs to be between the tick marks to indicate the exact time period. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
x axis tick marks
You have several choices on how to add your custom series.
Easiest for you may be to select chart, right click, choose Source Data, then add your new series. "Buckeye5" wrote in message ... When I remove the original x axis I don't know how to add in the custom x axis. The labels for the axis are quarters in a year. Thanks "Kelly O'Day" wrote: Buckeye5 You can use an XY chart with a custom X axis, aka dummy axis series. Here's a link to a tutorial on custom axes. I have a number of examples on my site. http://processtrends.com/pg_charts_custom_axis.htm Kelly O'Day http://processtrends.com "Buckeye5" wrote in message ... How do I add tick marks on the x axis for irregular time periods. Each period may have only 5 points of data or 12 points. The name of each period needs to be between the tick marks to indicate the exact time period. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
X axis tick mark over label | Charts and Charting in Excel | |||
Graph with large data range (hash marks on axis) | Excel Discussion (Misc queries) | |||
Line Wrap in Axis Tick Labels | Excel Discussion (Misc queries) | |||
Can tick mark labels be flipped about axis? | Charts and Charting in Excel | |||
Y-axis tick marks in middle of chart? | Charts and Charting in Excel |