Thread: Jon Peltier... I need your help!!

Hey Jon Peltier... perhaps you can help me out with this (or someone else)

I'm trying to make a complicated chart in Excel. Here's the deal:

I want to put in the same graph three data: investment, rating and # of insertions. I need to use three axis then... and I know you might be thinking now that I could check out the steps you have for adding a third axis to a graph. But a problem arises: I want to use a stacked column chart for both investment and # of insertions and a line chart for the audience measure.

This is the data for insertions:

Insertions Brand
Channel Stayfree Always Nosotras Category
TELEANTILLAS 93 117 63 273
TELEMICRO 58 0 21 79
CORAL-39 0 53 0 53
TELESISTEMA 50 0 0 50
ANTENA LATINA 38 0 0 38
AME 0 0 8 8
COLOR VISION 0 0 4 4


I have a similar table for the investment data.

Luckily, for the audience data, I have only crossed it with the channels, and not the channels and the brand.

I hope you can understand what I want.

It's "simply" adding a tertiary axis for a combined stacked column-line chart.

Thanks in advanced and sorry for my poor English skills, I hope I have expressed myself correctly.

Marcos