x-axis

  1. F

    Can you include only certain months in x-axis labels?

    Hi, I have a plot with hundreds of data points between 1992 and 2016. I am trying to show the seasonal variation in the data and want to only show the x-axis date labels say for Jan and Jun for each of the years between 1992 and 2016. However this cannot be achieved by simply changing the major...
  2. A

    Chart plotting x-axis with irregular intervals

    Hopefully I have provided a title that will help capture the proper audience and response. I have a set of data that represents elevations across a transect line. My goal is to produce a line graph that will represent the elevation change along the transect (think about looking at a profile...
  3. S

    Help Scaling X-axis needed.

    I'm currently recording a macro to to read a .txt file apply, then a function will be applied to the data and then graph it. However excel's x-axis scaling isn't as friendly to use as it appears. I need my data to begin being read at 100 centimeters but I only want the x axis to show spacing...
  4. L

    VBA to change x-axis category labels to Text or Timescale

    Hi, I am extremely new with VBA and have been trying for several hours on on how to change my x-axis label which now reads "1 to 12" to a string/text /timescale "Jan to Dec". my data structure looks similar to the below Dept Jan Feb March w 20 30 20 x 40 34 54 y...
  5. LRATOZ

    Import .CSV file and spread out over 360 points in X-axis on graph

    Hi, I am making an application that makes up a 360 degree skyline of a site in Excel 2010. If the site is reasonably flat I will get away with about 10 to 15 values (Azimuth and Elevation of objects in degrees). On sites where there are lots of buildings, masts, trees, etc. it can go up to 150...
  6. K

    Scale of 2nd x-axis

    Hello everyone I am making an excel grafh with two x-axis. Making these two axis is no problem, however, the 2nde x-axis is a binomial transformation of the first x-axis. Therefore, the scale is different. Is there an elegant solution to make the values of my second x-axis correspond to my...
  7. C

    Chart -- begin counting major intervals from the left

    Just for fun, I have been charting the points margin of the NBA Finals games this year in Excel, using a XY chart. I'd been using time intervals for games 1-5, values in reverse order, so with 12 minutes quarters, the major intervals were at 48, 36, 24, and 12. Last night's game went into...
  8. P

    x-axis label interval alignment

    I have 30-day data running from (eg) 16/04/2013 to 15/05/2013 to display on a graph. Since having intervals of 1 day on the x-axis overcrowds the labels I want intervals between them. However, I want the latest date (15/05/2013) to display on the right and the intervals to work backwards to the...
  9. Q

    Auto Expanding X-Axis

    To the Excel Gurus out there: Hi! I'm a newbie and I apologise upfront if I've missed this thread/question somewhere (I really have been searching a while now): I've a chart to represent data entered over the next 2 years, but I only want the X-Axis to cover the series where information has...
  10. D

    Help with a logarithmic x-axis problem

    Hi, I've been struggling with a graph I'm doing for a lab report, and I've been unable to find a solution online. I have two series, each with separate y-axes (linear) and both plotted on a logarithmic x-axis with the same x-axis values for both series. I expected the points on both series to...
  11. R

    Charting data - formatting x-axis

    I am trying to develop a x-y scatter plot for a set of data. I have created the chart. In column S beginning in cell 2, I have the values I want on my x-axis. These values are in the following form: Date_time frame. For instance, S2 contains 6/13/2011 8AM-10AM, S3 contains 6/13/2011...
  12. S

    Excel Scatter Plot Problem: Date/Time on x-axis

    I have dates (column A), times (Column B), and a dependent variable (Column C) in a straightforward arrangement in Excel 2007. I select both column A and B for the x-axis and in the Data Select window and Excel appears to understand that these columns are the collective x-axis. But on the...
  13. P

    Pivot table: Sorting the months

    Hi, Here is little background before I explain my question. I have a web application through which I download data on to a predefined worksheet in an Excel template. This template has many worksheets with predefined charts. After data download I run a macro/script (as part of download action)...

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