i have a data like this, temp 4,6,5,3,6,5
and want to creating a graphic for that, and i want to give a special color for major gridline of value 2 and 7, how do it could be done ?
Thanks
graphic limitation
-
-
This post isn't very clear.
How exactly is your data arranged? In a row or a column?
What are you trying to show? /How do you want it to look - sounds like a chart you want but it's not very clear....
-
If you are trying to say set an Upper warning limit at 7 and a lower warning limit at 2, why not add these as separate "series", maybe called Upper Limit (value as constant 7) & Lower limit (value as constant 2) & then plot these along with the actuals - you can then format the other 2 series to whichever colour suits you.
HTH
-
What additional data should it / do you want to show ??
Lets try to get a handle on exactly what you're trying to display before getting into complex VB solutions
-
Well, yes you can add series with VB, but you still have to define the values that you want represented....
Have a look at this site for the VB relating to adding chart series
http://www.geocities.com/jonpe…ckChartVBA.html#addseries
Hope this helps
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!