axis options

  1. B

    Find min and max dates to paste in 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...
  2. C

    Can't change the maximum value on the x axis...

    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...
  3. D

    Vba charts - add reverse axis order to existing code

    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 =...
  4. J

    Bubble Chart w/ Y-Axis Categories

    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...
  5. R

    Pivot Chart - adding data not related to chart (holidays)

    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...
  6. C

    Worksheet change vs worksheet calculate

    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...
  7. C

    Graphs, trends and series data Help needed

    <?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...
  8. S

    Scatter Plot Axis Options

    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...

Some videos you may like

This Week's Hot Topics

Top