ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Displaying data in bar form on a line chart (https://www.excelbanter.com/charts-charting-excel/74768-displaying-data-bar-form-line-chart.html)

expo

Displaying data in bar form on a line chart
 
I have a line chart that displays two sets of data. I have a third set of
data I would like displayed on the same chart but in the form of bars. How
do I do this?

Jon Peltier

Displaying data in bar form on a line chart
 
Add the data to the chart so you have three lines (or create the chart with
three lines to start with), select the one series, and use Chart Type on the
Chart menu to change it to a Line style.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"expo" wrote in message
...
I have a line chart that displays two sets of data. I have a third set of
data I would like displayed on the same chart but in the form of bars.
How
do I do this?





All times are GMT +1. The time now is 02:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com