I made a two series column graph. I would like to add a line that represents the average of the two series values. Can this be done? I got the line. I got the series columns. But I couldn't get them on the same chart at the same time.
I made a two series column graph. I would like to add a line that represents the average of the two series values. Can this be done? I got the line. I got the series columns. But I couldn't get them on the same chart at the same time.
Tom,
Assuming the data is in three columns: Data series one, Data series two, Avg of Dat one & Dat two. Go to the "Chart wizard" and under "Standard Types" choose "Column" then go to custom types and choose "Line-Column" and you should be set.
HTH
Casey
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks