Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / December 2003

Tip: Looking for answers? Try searching our database.

Step Line Charts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Carrie - 11 Dec 2003 16:06 GMT
Does anyone know how I can create a step line chart without having to have 2 data points per x-axis point.  What I want is a horizontal line until the next data point and then I want the line to go vertical.
Andy Pope - 11 Dec 2003 16:31 GMT
Hi Carrie,

You Will need some form of extra data to get excel to create a step
chart. Take a look at these methods.
(http://www.andypope.info/charts/stepchart.htm)

> Does anyone know how I can create a step line chart without having to have 2 data points per x-axis point.  What I want is a horizontal line until the next data point and then I want the line to go vertical.  

Signature

Cheers
Andy

http://www.andypope.info

Tushar Mehta - 11 Dec 2003 17:02 GMT
If you decide to go with a XY Scatter chart with error bars, you can
find step-by-step instructions at the Excel | Charts | 'Step Charts'
page of my web site.

Signature

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> Does anyone know how I can create a step line chart without having to have 2 data points per x-axis point.  What I want is a horizontal line until the next data point and then I want the line to go vertical.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.