| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create a chart with 6 bars for data and 1 total line
I have 6 products that I have created a bar chart for showing total units
sold for 5 years. I want to add a line (just one) that shows the total units sold for the entire product category over the same time period to the same chart. I tried combination chart but it changes 1/2 the product to line and keeps 1/2 of them bars... |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I create a chart with 6 bars for data and 1 total line
Hi,
Create a column chart for all the data and then select the series you want to plot as a line. Change the chart type for this series. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "ddavis13" wrote in message ... I have 6 products that I have created a bar chart for showing total units sold for 5 years. I want to add a line (just one) that shows the total units sold for the entire product category over the same time period to the same chart. I tried combination chart but it changes 1/2 the product to line and keeps 1/2 of them bars... |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I create a chart with 6 bars for data and 1 total line
That worked! Thank you - I had done this years ago but couldn't
remember...I knew it was simple, just couldn't remember :-)... THANK YOU! "Andy Pope" wrote: Hi, Create a column chart for all the data and then select the series you want to plot as a line. Change the chart type for this series. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "ddavis13" wrote in message ... I have 6 products that I have created a bar chart for showing total units sold for 5 years. I want to add a line (just one) that shows the total units sold for the entire product category over the same time period to the same chart. I tried combination chart but it changes 1/2 the product to line and keeps 1/2 of them bars... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Up/down Bars - Line Chart | 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) | |||
| Can a combo chart plot 4 variables? (3 bars,1 line) | Charts and Charting in Excel | |||
| create a chart using two columns for x & y, third for line data | Charts and Charting in Excel | |||
| How to display chart with three bars and one line? | Charts and Charting in Excel | |||
Linear Mode
