How can I change where the lines are drawn down to. I want the lines to go to the blue line not the pink one. I got this off a cool site recently and playing with it.
Found out a few nice tricks but cant figure this one out. Just want to change where the lines go to. See chart 2
Last edited by JK1234; 12-08-2008 at 02:50 PM. Reason: Solved it
I changed the data in each column - I never thought of that. I was looking to change it in the graphing formats somehow.
Hi,
the data for your label points comes from a VLookup on the Trend Data, which is the pink data series.
That's why the line of the label points to the pink data series.
The blue data series is an externally linked sheet. In your table on Sheet International Events, you need to change the formula to lookup the data points from the same source that the blue series takes its data from.
Or, you could forget about the lookup and enter the value manually. For example, if you enter 66% for the value for Note1, it will draw the black line down to the blue data series.
'zat help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks