Show Y axis data instead of X on barchart
Posted: Tue Jul 22, 2008 6:11 pm
Can someone tell me how to show the Y axis data on a callout instead of the X axis data. I have tried everyway I know, with no effect. I want the marker to read the MyNums(X) value instead of the month.
Bar1.Title = "Total Cards"
Bar1.Marks.Visible = True
Bar1.Add(CDbl(MyNums(0)), "Jan")
Bar1.Add(CDbl(MyNums(1)), "Feb")
Bar1.Add(CDbl(MyNums(2)), "Mar")
Bar1.Add(CDbl(MyNums(3)), "Apr")
Bar1.Add(CDbl(MyNums(4)), "May")
Bar1.Add(CDbl(MyNums(5)), "Jun")
Bar1.Add(CDbl(MyNums(6)), "Jul")
Bar1.Add(CDbl(MyNums(7)), "Aug")
Bar1.Add(CDbl(MyNums(8)), "Sep")
Bar1.Add(CDbl(MyNums(9)), "Oct")
Bar1.Add(CDbl(MyNums(10)), "Nov")
Bar1.Add(CDbl(MyNums(11)), "Dec")
WebChart1.Chart.Series.Add(Bar1)
Bar1.Title = "Total Cards"
Bar1.Marks.Visible = True
Bar1.Add(CDbl(MyNums(0)), "Jan")
Bar1.Add(CDbl(MyNums(1)), "Feb")
Bar1.Add(CDbl(MyNums(2)), "Mar")
Bar1.Add(CDbl(MyNums(3)), "Apr")
Bar1.Add(CDbl(MyNums(4)), "May")
Bar1.Add(CDbl(MyNums(5)), "Jun")
Bar1.Add(CDbl(MyNums(6)), "Jul")
Bar1.Add(CDbl(MyNums(7)), "Aug")
Bar1.Add(CDbl(MyNums(8)), "Sep")
Bar1.Add(CDbl(MyNums(9)), "Oct")
Bar1.Add(CDbl(MyNums(10)), "Nov")
Bar1.Add(CDbl(MyNums(11)), "Dec")
WebChart1.Chart.Series.Add(Bar1)