Pivot chart with stacked bar and single line by day

**tjwhite123** · 09-01-2014, 12:14 PM

Hi,

I am trying to build a Pivot Chart built with date on the horizontal access and two types of chart included:
- Stacked bar chart for pageviews by user type utilizing the x axis
- Single line chart that shows average time on site on the y-axis. This needs to be a single line, aggregating all the user types into one line.

The problem I am having is that when I create the stack with user type in my Legend field, this then breaks out the Average Time on Site by channel too.

Is there a simple way to create a chart with stacked bars by day with a single aggregated line showing average time?

Thanks

**noboffinme** · 09-02-2014, 12:52 AM

Please post an example so I can see what you have done so far.

Thanks

**tjwhite123** · 09-02-2014, 05:12 AM

Attached is a file with two charts in tab Sheet4. I want my chart to look like the top one (titles 'Example of what I want but with a stacked bar...' but with the bar stacked by User Type. The second chart shows what happens when I build the chart the same way but then add user type as a stack!

Any help on this is very much appreciated.

Thanks

Attachment 342670