ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Need vertical separators rising from the X axis. (https://www.excelbanter.com/charts-charting-excel/62658-need-vertical-separators-rising-x-axis.html)

Peter Jason

Need vertical separators rising from the X axis.
 
I have Access2003 & WindowsXP and MSGraph2000.

*****

I have many charts based on MSGraph using xtab queries as the sources.

All works well except for one small problem.

Since I have all data shown monthly for over 7 years, this adds up to a
pretty dense chart, which is excellent for discerning trends.

(The X axis is always the "yyyymm" one.)

Now what I need is a simple VERTICAL separator (rising from the X axis) on
the chart to separate the years in either calendar or financial years.

The Y axis has these built in and their separation can be adjusted.

Why not for the X axis?

Can someone help me to insert such separators, or is there 3rd-party
software to do this?

Please help, Frank

***



Tushar Mehta

Need vertical separators rising from the X axis.
 
Consider adding major gridlines for the x-axis.

And, please pass on the answer to Frank Martin of Australia who asked
the exact same question as you.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have Access2003 & WindowsXP and MSGraph2000.

*****

I have many charts based on MSGraph using xtab queries as the sources.

All works well except for one small problem.

Since I have all data shown monthly for over 7 years, this adds up to a
pretty dense chart, which is excellent for discerning trends.

(The X axis is always the "yyyymm" one.)

Now what I need is a simple VERTICAL separator (rising from the X axis) on
the chart to separate the years in either calendar or financial years.

The Y axis has these built in and their separation can be adjusted.

Why not for the X axis?

Can someone help me to insert such separators, or is there 3rd-party
software to do this?

Please help, Frank

***





All times are GMT +1. The time now is 12:07 AM.

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