Graphs, trends and series data Help needed

[craig80]

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Hi All,<o></o>
<o></o>
I currently have a graph based on 7 data sets, 5 are similar. 2 are % trends. I have a column graph, with values on top of each other, in weekly increments.<o></o>
<o></o>
The problem I am having is that I have ended up with 3 % trends... and i need to move one from there to the body data!<o></o>
<o></o>
Can anyone help?<o></o>
<o></o>
Thanks<o></o>

Craig<o></o>

 

[Jared_8878]

select that data series in the graph, right click "change series chart type"

 

[craig80]

Sorry, this isnt fixing it.

C

 

[gardnertoo]

Are the two percentage trends something other than stacked columns, maybe line or x-y plot? I think that's what Jared was getting at; if the series that is plotting as a percent is supposed to be one of the stacks in the column chart, changing it from series type "Line" to series type "stacked column" should be the fix. It might also be an issue with primary or secondary Y axis.

You might have to rebuild the chart, starting with the five series that belong in the stack, getting that all the way you want, then adding the other two.