• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Price Quality Matrix

mr_hiboy

Member
Hi,

I'm trying to create a price/quality matrix, started off thinking it was easy, but hit a brick wall!

If you imagine this dataset, a list of competitors, a price which would set the Y axis and Quality score that would be the X axis.

E.g. Comp2 would be lower on the price and quality scales.

Any help would appreicated!
Paul

Competitor Price Quality
Comp1 0 -5
Comp2 100 -3
Comp3 150 -1
Comp4 200 1
Comp5 175 4
Comp6 125 5
 
Thanks guys.

With a tweak or two Luke's example will work.

Ideally I'd like to set the Y axis maximum scale to based on a value set in cell A13 for example.

Also I've removed all gridlines, but again I'd like to set one line based on data in cell A14 (basically a mid point), so we get four quadrants.

Assuming it'll have to be done using vba?

Cheers
Paul
 
Hi Luke,

Thanks for the pointer.

This code is setting the x axis, not Y, where am I going wrong?

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$B$26"
ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlCategory) _
.MaximumScale = Target.Value
Case Else
End Select
End Sub
 
Hi, mr_hiboy!
Tried changing xlCategory by xlValue (or if a 3D chart by xlSeriesAxis)?
Also check the Chart.Axes built-in help.
Regards!
 
Hi, mr_hiboy!
Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.
Regards!
PS: Long time ago when you last visited your ophthalmologist? :rolleyes:
 
Back
Top