Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
I need separators on the X axis of a chart.
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 *** |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
I need separators on the X axis of a chart.
What sharp little eyes you have!
"Tushar Mehta" wrote in message om... Apparently, Frank Martin of Australia and Peter Jason of New Zealand have the same query -- word for word. -- 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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |