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
Bookmarks