How to make this graph in Excel?

**Beg9inner** · 02-10-2013, 06:16 PM

graph.jpg

Is it possible to make this graph in excel? offcourse by using data
Negative differentiation = 10
Positive differentiation = 40
Compettitve reference = 60

Thanks in advance.

Best regards
Beg9inner

**Beg9inner** · 03-08-2013, 11:30 AM

anyone that can help?

**MrShorty** · 03-08-2013, 12:02 PM

I think what you want could be accomplished by using some variation of a stacked column chart or a stacked area chart.

available chart types: http://www.excelforum.com/excel-char...-in-excel.html
column charts: http://office.microsoft.com/en-us/ex...in=HA001233737 each value would be its own data series
area charts: http://office.microsoft.com/en-us/ex...in=HA001233737

**dagagnon** · 03-08-2013, 12:54 PM

Dim myChart As Chart
Set myChart = ActiveSheet.Charts.Add

myChart.SerieCollection(1).Name = "Your serie's name"
myChart.SerieCollection(1).Values = "=" & myWorksheet.name & "!&" & COL_START & "$" & LINE_START & ":$" & COL_END & "$" & LINE_END 
myChart.SerieCollection(1).XValues "=" & myWorksheet.name & "!&" & COL_START & "$" & LINE_HEADER & ":$" & COL_END & "$" & 
LINE_HEADER

This will create a chart with one collection that can have many values per serie.

You can find a lot of example on the web.

**Beg9inner** · 03-09-2013, 07:33 AM

Thanks to you both

I will try

Cheers

How to make this graph in Excel?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to make this graph in Excel?

Re: How to make this graph in Excel?

Re: How to make this graph in Excel?

Re: How to make this graph in Excel?

Re: How to make this graph in Excel?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions