horizontal axis

  1. A

    Switching x-axes from horizontal secondary to primary

    Hello! I have a chart with 4 axes (i.e. horizontal primary, horizontal secondary, vertical primary and vertical secondary). I'm using Excel 2016 and need to switch the horizontal secondary axis at the top (date) with the horizontal primary axis at the bottom (number). Unfortunately, I...
  2. M

    Macro to change date format on horizontal axis on a chart upon button click

    Hi all - I've been working on creating a simple macro that changes the formatting of the horizontal axis on 9 charts. We have an internal software that refreshes dates always using one format and we want to present those dates in a different format for presentation purposes. What I want to...
  3. E

    Autoscaling (with fixed range) the x-axis of a line chart?

    Hi I'm a bit confused on this one... In Excel 2007, I am using a trendline on a "Line with Markers" chart. I have Date on the X-axis and Weight on the Y-axis. I'd like to do a 1-year projection from the last date where there's a Weight value plotted on the chart. For example, if I have...
  4. C

    Adding horizontal (category) axis labels on an X-Y scatter plot

    I have been trying for hours to create an X-Y scatter plot with horizontal labels. Below is my data (column A- Horizontal axis and column B- verticle axis). When I try to create XY scatter plot in Excel 2010, horizontal (category) axis labels option is greyed out (disabled?). Exact serial nos...
  5. Prevost

    Horizontal axis formatting on all charts EXCEPT scatter

    Hi There, Maybe I am missing something, but I believe the only chart type that gives the flexibility to display all the data you want (when working with date & time values as the x-axis) is the xy scatter. In this, I can set the increments to whatever I want (1 min, 1 hr, 1 day, etc...) and...
  6. D

    Tricky Horizontal Axis Display Issue Excel 2013

    Hi, I am creating a simple spreasheet for a medication dosing regime. The problem I am having with the horizontal axis labels are best explained in screenshots, but I cannot post those. Therefore the links Click here for the data I need to display as 2 charts. Click here for the display as...
  7. Prevost

    adjusting time based horizontal axis on stacked bar chart

    Hi There. I have 19760 date & time values in column A (it starts in June and each row is incremented by 1 minute). Columns B, C, D, and E have energy uses for each minute for different pieces of equipment. I want to create a stacked bar chart showing the total energy used for each minute but in...
  8. Prevost

    Plotting Points in between horizontal date ticks in chart

    Hi There. Is Excel capable of creating a horizontal graph whose major ticks are the first of each month and also plot two series of data whose dates do not align with each other? For example, I am creating a 2D Line Chart with markers and formatting the horizontal axis to start at the beginning...
  9. Prevost

    Date & Time Cell Format for Chart Horizontal Axis

    Hi There. I format my cells to the custom format of dd/mm/yyyy hh:mm:ss to use for a chart. It displays the chart correctly for XY Scatter but this type also doesn't recognize it directly as dates (it converts it to numbers which can then be transferred to dates). When I change the chart type to...
  10. Z

    Chart Category (Horizontal) Axis Labels Stuck As Numbers

    Okay, so I have a bar chart I've created whose data source is a range of cells (Progress!$L$4:$Q$6). The category labels (horizontal axis) of the chart USED to reflect the category names as text values (nameA, nameB, nameC, nameD, and nameE), which is what they were supposed to do. I should...
  11. cvincent

    Excel Double Axis Graph

    My double axis chart is tracking $ values on the left and count on the right. Dates are on the horizontal axis, with the oldest date to the right. The count is charted correctly; i.e. the dates correspond to the count. But the $ amounts are charting backwards. In other words, the $ amounts...
  12. P

    Combine Data Table with X-axis

    In Excel2007, I have found that some of the data tables in new charts are combined with the labels on the primary (lower) horizontal axis. On others, there are both labels on the axis and on the data table. How can I consistently create graphs where the axis labels are shared with the data...

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