axis options

Hello. I have a code to find min and max dates in Range("A") and Range("A2") and a MsgBox displaying min date(in format number) and another MsgBox displaying min date (in format number). This is my code and works fine: Sub minmaxdate() Dim rng As Range Dim ws As Worksheet Dim ch As...

Hi all I've just produced a chart with bins 1, 1.5, ... , 6, comprising 11 values in total. When I create a chart Excel 2007 puts the values 1-11 on the x-axis. I've read in various places (e.g.http://www.dummies.com/how-to/conten...007-chart.html) that going into Format Axis > Axis Options...

Using Windows 7 Office Excel 2010 I'm trying to add a reverse order for the axis for a chart that populates based on various data. Because of this, some (NOT ALL) of the charts need to have the reverse order = False. I have tried adding the statement (.Axes(xlValue).ReversePlotOrder =...

I have a two dimensional table similar to: Circle Square Triangle Red 2 5 3 Blue 7 1 6 Green 3 4 8 Orange 1 0 9 and want to create a bubble chart where the shape category is on one...

So I have a sales variance chart for a customers stores. One of the big factors when looking at y/y data is when holidays fall on different days/weeks from year to year. My data is summed up to a "week ending date". I have a separate list of holidays for the year and what w/e date they are on...

I've got some code that is driving an axis scale based on a few cells. What I would like to do is have the axis be driven by calculated cells instead. I'm thinking I need to change the code below to worksheet_calculate, but (if you haven't guessed already), I'm not sure of the changes that need...

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p>:confused: </o:p> Hi All,<o:p></o:p> <o:p></o:p> I currently have a graph based on 7 data sets, 5 are similar. 2 are % trends. I have a column graph, with values on top of each other, in weekly...

Hi everyone, I need to do a scatter plot with the following data: Month---Peter---Lyne Jan-09 5 4 Feb-09 3 1 Mar-09 4 2 Apr-09 ....... May-09 ....... Jun-09 Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 Dec-09 Jan-10 The chart looks great, except that is would start with Nov-08, have...