x axis

  1. G

    Placing the secondary Y axis below the X axis

    Hi guys This issue at first seemed really simple but I have been at this for hours and cannot make any progress. I have search a ton of articles, boards and all the solutions posed do not fix the issue i am facing, which is to place the secondary Y axis (which is a calculated field, showing...
  2. S

    Trend Line X Axis longitude problem

    Hello Everyone, Many thanks in advance. I have an issue where by a data set on a XY scatter graph is joined with Linear Trend line. It is used to show the routes a ship takes and the scatter graph has a map as a back drop, x axis is longitude and y is latitude. The longitude (x axis) starts...
  3. N

    Empty values in x axis

    Hi, Excel pro's, I have a problem with x axis values. I need to see all of years in the chart as I see now, but Excel includes all empty cells. But I don't need them, because it looks unpresentable. I tried to uncheck empty values on axis values options, but there too many values, so I can't...
  4. H

    Excel 2013 - x Axis label alignment on a line chart (how to rotate labels)

    I know how to do this in Excel 2010 but I can't seem to find options for this in Excel 2013. I would like to rotate my x axis labels. In Excel 2010 there is an option where you can set the angle of an x axis label. But when I choose Format Axis in 2013 I cannot see an option for alignment...
  5. S

    Can I make a custom x-axis??

    I need my x axis to range from 100-2500 but I want it to appear as intervals as 500 with the initial starting value of 100 not being shown. The axis should read 500,1000,1500,2000,2500. Can this be done and how?
  6. V

    How to plot chart by showing continuous month data

    Hi All, Please see data below. <colgroup><col><col><col><col><col><col></colgroup><tbody> Employee # Employee Name Designation Senior/Junior Allocation Start Date Allocation End Date 123 ABC Engineer J 1-Apr-14 456 DEF Engineer J 1-Apr-14 789 GHI Manager J 1-Apr-14 112 JKL manager...
  7. K

    buble graph x axis putting values in order rather than using value

    Ok I have a bubble graph, works fine once it's working. But i'm changing the data (coping from another workbook and pasting) and sometimes (no pattern as to when yet) it stops treating the x values as it should and instead puts them in the order they appear in the list. Eg with the following...
  8. J

    incorrect values on line chart X axis

    Using Excel 2010, I created a very simple line chart showing activity of a certain type, like this: Column A (Date of Report) 01/06/14 01/13/14 01/28/14 02/03/14 02/10/14 02/28/14 03/07/14 03/14/07 03/21/14 03/28/14 04/04/14 04/18/14 Column B (Number of Incidents Reported) 700 374 372 359 410...
  9. J

    Toughy! Multiple X-Axis Interval Tick Marks on Line Graph?

    Here's a tough one for ya. I have a time series plotting daily return data across 1.5 years. My line chart looks great, except for the x-axis. The beginning data does not start exactly at the beginning of the 13-week quarter, and not all quarters are exactly 13-weeks. Q4 is 13 weeks and 3 days...
  10. 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...
  11. M

    Plotting Chart data Accurately

    I have several columns of stock data including the date. All data for all dates that are not high or low for a given period have been removed. I wish to plot this zig zag line that alternates between the last top and the next bottom on a pre existing chart that contains all of the historical...
  12. D

    Take #N/A's out of the x axis

    I have a set of data that always changes and is put into a graph for better viewing. Sometimes I have more data than other days but I do not want to show #N/A in the x axis I have tried many things and nothing has worked
  13. S

    VBA to plot several line chart series on a common date X axis

    Hi guys.... I have a Workbook (Excel 2010) with several Worksheets - each Worksheet represents a business loan, and each loan has a different start and predicted end date. On each worksheet I have a column with the Next Payment Date, and another column with the Balance after the payment has...
  14. C

    Scatter with smooth line - X axis values

    Hello, I am working on a scatter smooth line chart and I am having an issue with the X axis. I have 5 points on my charts and excel is doing an interpolation to get the smooth line. Values one the X axis go from 0 to 6 while I would like to customize it to have: "Put 40" for point 1, "Put 25"...
  15. R

    X - Axis, Cant get excel to use the correct scale.

    Hello, I am making a mortgage calculator that you can use to compare two different scenarios and have the results displayed on a graph. The problem is that Excel is plotting the data based on the location of the data for the x axis and not the value in the cell. I have a balance in one column...
  16. J

    Pivot Chart of Counts - no entry when count = 0

    I want to show from a set of values that for some values there is a high count and for others a count of zero (result in both tabular and chart form). I make a pivot table with my range of values drug to both the Row Labels and the Values (as Count) and it works for for values where the count...
  17. T

    Line charts

    This is the problem: I'm trying to make a force x velocity line graph with pre and post variables in this chart. The problem is that the post variables for velocity doesn't fit in, in the x axis with the pre variables. How do I do that?? PS: Sorry for bad english :)
  18. B

    Graphing Vlookup as NA() X Axis Problem

    I'm trying to graph a vlookup column where the non-values are coded with NA() so that they do not plot. When I add the data series to the graph if plots properly; however, it skews the x axis (a date/time combo format) and will not let me set date/time before a certain value (e.g. the x axis...
  19. B

    XY Plot x axis date/time maximum help

    Hello, I'm having trouble with excel 2007 plotting my maximum date/time on the x axis properly. I have set the maximum value as 40155.08333 (12/8/09 02:00); however, the maximum value keeps plotting as about 40155.2 (12/8/09 04:45 ish). I am thoroughly stumped. Ancillary information: The x...
  20. R

    Trying to use a cell reference value in X Axis value of Chart

    Hi I'm trying to use a cell reference value in the X Axis labels of Chart. For example the static axis labels reference would be =Student!$B$26:$R$26 However instead of it being $B$26, I need it to be $B with whatever Row number my named range "ColumnNumber" returns. Many thanks Ronan

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top