simple bar and line chart

[betsy]

I have data that looks like this

Delivered % HTML Opens % Click % delivered
Monday 89.3% 13.7% 1.8% 5,884,287.00
Tuesday 89.2% 12.2% 1.5% 15,885,832.00
Wednesday 89.4% 12.0% 1.6% 17,088,488.00
Thursday 89.1% 13.2% 1.8% 14,042,377.00
Friday 89.5% 13.3% 0.0% 5,647,584.00
Saturday 92.3% 0.00 0.00 30,005.00
Sunday 89.2% 0.00 0.00 29,958.00
89.3% 12.7% 1.7% 58,608,531.00


I want to create a bar chart listing by day delivered, open and ctr as a bar
chart and than the delivered volume as a line graph>

Can you help?

Thanks.
Betsy

 

[Shane Devenshire]

Hi,

It's pretty easy in 2003 but a little more of a hastle in 2007. Here is the
2003 way. Suppose your data runs from A1:E8.

1. Highlight the A1:A8 hold down the Ctrl key and Highlight C1:E8.
2. Click the Chart Wizard button
3. Choose Cutom Type, and pick Line - Column on 2 Axes and click Finish
Because of the order of you data layout the wrong series will be lines and
columns, but you get the idea.
4. Select one of the Bars and choose Chart, Chart Type, Line
5. Select the other Bars series and press F4 - this will convert this one to
a line also.
6. Select the Delivered line and choose Chart, Chart Type, Column

We are using two axes because the number span such a large range from <1
(1.8%) to tens of millions.