Custom type chart
How can I make a chart with two series of Columns and one serie of line? For
example, I need to, in the same chart, show Product A's and B's net sales from several months by two series of columns, and then show the percentage of A to B (A/B) by a line. |
Custom type chart
Create a chart with all of the data series in a clustered column chart.
Then select the data series for the one you want as a line, right-click, and select chart type and change that one to a line. -- __________________________________ HTH Bob "Ask MS" wrote in message ... How can I make a chart with two series of Columns and one serie of line? For example, I need to, in the same chart, show Product A's and B's net sales from several months by two series of columns, and then show the percentage of A to B (A/B) by a line. |
Custom type chart
Thank you, Bob, that is right!
"Bob Phillips" wrote: Create a chart with all of the data series in a clustered column chart. Then select the data series for the one you want as a line, right-click, and select chart type and change that one to a line. -- __________________________________ HTH Bob "Ask MS" wrote in message ... How can I make a chart with two series of Columns and one serie of line? For example, I need to, in the same chart, show Product A's and B's net sales from several months by two series of columns, and then show the percentage of A to B (A/B) by a line. |
All times are GMT +1. The time now is 11:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com