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

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top