I am hoping that someone here is expert enoughto be able to help with a chart I need to create. Here goes!
I need to create a 'mixed' bar and line chart/graph showing the following data that I have prepared
'Stock holding (days)' = two digit numbers, say 0 to 52 and in bar form
'Stock value (£)' = Anything from £1 to £100,000 but shown as a data label only at the top of the each 'stock holding' data bar
'Stock holding target (units)'= 1 to say,10,000 and shown horizonally as a line on each of the 'stock holding' bars
I hope this makes sense but if not, please ask me the questons yo need to give e a possible answer. I might be asking for something that is not possible but he idea of this chart is to plot te stock holding in days against te stock holding target and showig the current stock value for each product. HELP!!
I need to create a 'mixed' bar and line chart/graph showing the following data that I have prepared
'Stock holding (days)' = two digit numbers, say 0 to 52 and in bar form
'Stock value (£)' = Anything from £1 to £100,000 but shown as a data label only at the top of the each 'stock holding' data bar
'Stock holding target (units)'= 1 to say,10,000 and shown horizonally as a line on each of the 'stock holding' bars
I hope this makes sense but if not, please ask me the questons yo need to give e a possible answer. I might be asking for something that is not possible but he idea of this chart is to plot te stock holding in days against te stock holding target and showig the current stock value for each product. HELP!!
