ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   vertical line graphs (https://www.excelbanter.com/charts-charting-excel/186775-vertical-line-graphs.html)

MGabby

vertical line graphs
 
I am trying to recreate a graph that I have seen in a pdf through Excel - a
vertical line graph. Can you do that in Excel and if so, how?

Andy Pope

vertical line graphs
 
Hi,

To create vertical line charts you need to use xy-scatter rather than Line.

Stephen Bullen has a example.
http://www.oaltd.co.uk/DLCount/DLCou...e=FunChrt2.zip

Cheers
Andy

MGabby wrote:
I am trying to recreate a graph that I have seen in a pdf through Excel - a
vertical line graph. Can you do that in Excel and if so, how?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Jon Peltier

vertical line graphs
 
Try a Dot Plot:

http://peltiertech.com/Excel/Charts/DotPlot.html

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


"MGabby" wrote in message
...
I am trying to recreate a graph that I have seen in a pdf through Excel - a
vertical line graph. Can you do that in Excel and if so, how?





All times are GMT +1. The time now is 06:10 AM.

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