This discussion is archived
1 Reply Latest reply: Feb 1, 2013 12:42 PM by Srini VEERAVALLI RSS

11g Stacked Bar/Line Chart Question for the Gurus out there

Steve J Newbie
Currently Being Moderated
Got a question regarding a stacked bar/Line chart and pivot table.
Screen shots in a word doc [https://dl.dropbox.com/u/49956383/Stacked%20Bar%20Chart%20with%20Line.doc] showing the column formulas and layout.

I have a graphed pivot table using a stacked bar/line graph with the columns of revenue stacking by to 2 transactions types over a timeline in the rows, this is all fine looks like I want it to.
Then I have the line as an RSUM of the Cumulative Revenue but it is also breaking it into the 2 transaction types, I would like to keep the bars as the two transaction types but condense the line into a single cumulative revenue.

How would i be able to condense the line without also condensing the stacked bar?

Thanks in advance for any assistance.

Edited by: Steve J on Feb 1, 2013 11:53 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points