y axis

  1. H

    Constructing a custom Y axis for a chart

    This might be a simple question but I am looking to make a bar graph using what is in the data picture The scale I am looking to use is the second picture - with 1 being completely false and 7 being completely true. In the graph I am looking to have the graph show completely false at the bottom...
  2. J

    Area Graph start on X axis

    Hello all, I've searched all over and for some reason I can't figure out how to get my Area chart to start on the Y Axis I have forecast for 5 years and I want Year 1 data to start on Y axis and cover my table below. Right now data is offset to the middle of the table This seems like an easy...
  3. R

    Column Chart - columns overlapping Y axis

    I have eight data points in a column graph, ranging from -13.9% to +4.5%. The Y axis of zero is in the middle of the chart. The columns overlap the Y axis, and this overlap grows as the column width is increased. At a 1 column width, there is no overlap. At a width of 5, there is a light...
  4. B

    How to set the Y axis using VBA?? Help

    Hi, I am not very good with VBA but, I'm trying to change the Y Axis to a value in a cell (basically i'm trying to tighten up the auto setting). I would also like it to only happen to a specific chart (Chart 45) every time the cell changes. I have managed to find some code that I think may work...
  5. P

    Graphing XY Plot with defined Axis

    Good Morning, For work, I am trying to graph profitability by state (could be product line, customer, etc) with Net Sales on the X axis and Operating Income on the Y. When trying to graph this in excel, it treats the selected data as two seperate series and doesn't plot based on the values...
  6. K

    Dates on Y Axis Monthly Interval

    Hello, Please send guidance regarding dates on y axis. How can the spacing be set to reflect months? I am presently using a Line Chart which recognizes dates on x axis but not the y. Any help is much appreciated.
  7. S

    charts - how to plot categorical data on Y axis and contiuous on X axis

    hi, i was wondering if it is possible to plot categorical data on the Y axis and contiuous on the X axis in excel. what i am trying to achieve is as follow (BTW, I know i can do this in reverse, but i need the categorical data on the Y axis). as an example, my 4 y axis variables have the...
  8. E

    Add additional axis to chart using toggle button

    Hi I need to add an additional Y axis to a line graph and an additional line to go with it using a toggle button. eg: once the user clicks on the toggle button the additional line and axis will appear on the graph then click it again to remove the additional line and axis. hope this makes...

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
Back
Top