Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formatting Gridlines on charts?
- Thread starter neiljabba
- Start date
SkipVought
Programmer
Hi,
Why not add a new data range, with ZEROES before the breakpoint and ONES after.
After adding the new series, select it and change the Chart Type to LINE or whatever and format accordingly.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
Why not add a new data range, with ZEROES before the breakpoint and ONES after.
After adding the new series, select it and change the Chart Type to LINE or whatever and format accordingly.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
- Thread starter
- #3
Thanks skip
I guess its my fault for not being clear enough. The e.g. was just that more specifically is it possible on say a bar chart to have different gridlines say multi colours but thats only another example.
I suppose Im asking how to access the properties of the chart down to the individual gridlines , even if this is a VBA requirement.
Cheers
I guess its my fault for not being clear enough. The e.g. was just that more specifically is it possible on say a bar chart to have different gridlines say multi colours but thats only another example.
I suppose Im asking how to access the properties of the chart down to the individual gridlines , even if this is a VBA requirement.
Cheers
SkipVought
Programmer
The GridLines Object has no further granularity. You have to perform "tricks" to do things like what you are conceiving.
Check out the John Walkenbach site. He has a great book on Excel Charts and feature alot of tips 'n' tricks. I have already stated just one of these techniques. The dividing line can move with the current data, for instance a Current Date Line. It can be a simple formula in the data that reflects a Current Date Line in the chart.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
Check out the John Walkenbach site. He has a great book on Excel Charts and feature alot of tips 'n' tricks. I have already stated just one of these techniques. The dividing line can move with the current data, for instance a Current Date Line. It can be a simple formula in the data that reflects a Current Date Line in the chart.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
- Status
Similar threads
- Locked
- Question