x-axis

Hi there! I am trying to create a clustered column chart that compares multiple clam species population densities at a single beach site over time. Ultimately, I want to compare the densities of the same species clams at different times at the same place. On my x-axis, I want to have the...

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

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

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

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

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

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

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

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

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

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

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

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

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