Horizontal Guage Chart - how to?

**JonPugh** · 12-09-2009, 08:30 AM

I have been asked to replicate a chart for a report that I have to produce. I have attached a picture of what I need to achieve.

Is this possible in Excel? If so can somebody guide me through it?

Thanks in advance.

Jonathan

**Andy Pope** · 12-09-2009, 08:39 AM

you can do it using a xy-scatter. The markers are just standard markers, unless the direction of the triangle is suppose to impart some information.

The slide part could be additional series or error bars.

What actual data do you have?

**JonPugh** · 12-09-2009, 08:53 AM

Andy,

I have attached some example data. What is needed are the MSFT values above the axis line with the others below. The direction of the triangle is just to point at the axis.

Thanks for your reply.

Joanthan

**Andy Pope** · 12-09-2009, 09:26 AM

yes, xy-scatter with error bars will do it.

**JonPugh** · 12-09-2009, 09:44 AM

Andy,

Your a star. I would not have had any idea how to do that.

Thanks
Jonathan

**JonPugh** · 12-09-2009, 09:51 AM

Andy,

Just noticed if I have a lot of these they all go down in a line (one set of results on each line). Is it possible to keep them on the same line if they do not overlap?

Sorry - everything gets complicated.

Jonathan

**Andy Pope** · 12-09-2009, 02:00 PM

The vertical position of an item in the chart can be controlled via the Y value.

**JonPugh** · 12-10-2009, 05:10 AM

Andy,

Thanks for all your help. I think I understand the chart except for one thing; How did you do the upside down triangle for the top value?

I can see that you had a shape drawn. How did you incorporate this into the chart?

Jonathan

**Andy Pope** · 12-10-2009, 05:14 AM

Sorry should have explained.

I used the autoshape as a custom marker. Create and format the shape as required.

in xl2003 and older you can use Copy shape, select series, paste.

in xl2007 you can use the same techinque but there is also now a 'Clipboard' button on the Marker Fill formatting dialog.

**JonPugh** · 12-10-2009, 05:31 AM

Andy,

Cheers. Brownie points with my CEO!

Jonathan

Horizontal Guage Chart - how to?

LinkBack

Thread Tools

Rate This Thread

Display

Horizontal Guage Chart - how to?

Re: Horizontal Guage Chart - how to?

Re: Horizontal Guage Chart - how to?

Re: Horizontal Guage Chart - how to?

Re: Horizontal Guage Chart - how to?

Re: Horizontal Guage Chart - how to?

Re: Horizontal Guage Chart - how to?

Re: Horizontal Guage Chart - how to?

Re: Horizontal Guage Chart - how to?

Re: Horizontal Guage Chart - how to?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions