line chart question - Possible to make the line transition from point to point via 95-degree angles?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike C - 19 Apr 2008 07:03 GMT

I am making some line charts and am wondering if anyone knows a simple
way to have the lines transition from data point to data point in
crisp 95-degree angles, rather than direct lines as is the default.

Thanks for any suggestions.

Reply to this Message

Earl Kiosterud - 19 Apr 2008 18:56 GMT

Mike,

I think your requirements need clarification. If it's a line chart, then the items on the x
(category) axis will be equally spaced, and the angles at each point will only be 95 (or
any) degrees for certain values of the data points. What do you want to adjust to force
these angles?

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

>I am making some line charts and am wondering if anyone knows a simple
> way to have the lines transition from data point to data point in
> crisp 95-degree angles, rather than direct lines as is the default.
>
> Thanks for any suggestions.

Reply to this Message

Mike Middleton - 19 Apr 2008 23:19 GMT

Mike C -

If you're referring to a "step chart" with 90-degree angles, Tushar Mehta's
web page might help:
http://www.tushar-mehta.com/excel/charts/step_chart/

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

Reply to this Message

Rate this thread: