Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column and line chart help
I need to create a combination column/line chart for 2 series. Each series
has 3 separate entries. Example, Series 1=salesman A sold 200 cases of item x last year, then sold 250 cases of item x during our promo period, and finally sold 275 cases of item x after the promo ended. Also, Series 2=salesman A sold a TOTAL of 5000/6000/8000 cases of all items we stock last year/promo/after. I have no problem getting it to work with 1 set of data as listed above with the item x data in colums and all cases data as a line above each column. But can't get it to work with 7 salesmen. The All items shows up as 3 line separate graphs centered over the middle column for each salesman. I would either like to have 7 separate lines of each group of 3 columns, or 1 long line that runs the whole width of the graph area. Any help would be appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
Adding a line to the line/column chart? | Charts and Charting in Excel | |||
How to add a Vertical Line to a Column or Line Chart with two axes already in use? | Charts and Charting in Excel | |||
Chart Type - Line Column adding a 2nd line | Charts and Charting in Excel | |||
How do I add an extra line to a line-column chart? | Charts and Charting in Excel |