Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
simple bar and line chart
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
simple bar and line chart
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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "betsy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show random labels in simple line chart | Charts and Charting in Excel | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
Create simple line graph in Excel!!!!! | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Excel 2003 - Drawing a Simple Line - Dissapears | Excel Discussion (Misc queries) |