Integrated bar chart and line chart

[Boffita]

Hi,

I have the following columns:-

Date of Count (Column T)

No. of Bins Counted Average Daily Total (Column U)

Number of Goods in Bin Accuracy (Column V)

Average Daily (Column W)

Percentage of SKU accuracy (Column X)

Average Daily Percentage of Lot Code accuracy (Column Y)

I am looking to have a combined Bar and Line Graph with the abov
columns. I want column T to be on the X Axis, and there to be two
axis. Column U will be numeric, and use the first y axis, and column
V,W,X will be a percentage figure, which will be related to th
secondary y axis. I can't get it to work.


Please help

Many thanks,

Parvee

 

[Bernard Liengme]

1) Select the 6 columns of data
2) Make a Column chart (Bar charts have x-values vertically)
3) In the chart, right click on the data for a series to be made a Line;
select Chart Type and select line. Repeat fro other data series
4) In the chart, right click on a data series to use second y-axis; select
Format Data series; open Axis tab and check the Secondary Y-axis box
Repeat for other data series