Hello there,
I need help with something that I guess is quite basic, putting labels on the X axis using VBA
the graphs I need are extremely simple
there are two columns that originate from a single series, two cells one on top of the other (D27:D28)
on the X axis I want to use the labels that are two columns to the left of the data (B27:B28), that's all I need.
However it is so basic that I am finding nothing looking around in forums.
Today I started using macros -- all in this the macro of the workbook I compiled looking around in forums and help files
I attach the file --
thanks a lot!
Code:Sub MakeChart() Dim rngData As Range Set rngData = ActiveSheet.Range("B27:B28,D27:D28") With ActiveSheet.Shapes.AddChart(xlColumnClustered, 20, 20, 300, 200).Chart .SetSourceData rngData End With End Sub
I think I want to do something like what Bagullo wants. The attached output (data is sensitive so I generated a pdf), I want to replace the x-axis bin numbers with non-numerical labels. It's a scatter plot, but I want to replace the bin number values with names. Any ideas?
Thank you,
ML
Last edited by MattLangholtz; 11-13-2009 at 02:16 PM. Reason: Attachment change.
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks