ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   x axis tick marks (https://www.excelbanter.com/charts-charting-excel/129928-x-axis-tick-marks.html)

Buckeye5

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.

Kelly O'Day

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.




Buckeye5

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.





Kelly O'Day

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.








All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com