X Axis Dates Not Appearing Correctly In Combined Chart
Jun 2, 2014
I got a problem with displaying my dates correctly on the X-axis of my combined column - line graph. For some reason X-axis labels appear as consecutive numbers with regards to number of data points. Please see attached.
Also, why does the indent change as seen in this screenshot?
Last but not least, how can I prevent my secondary axis label from coinciding with the labels as seen here?
I have data that shows titles as 2-Feb, 2- Mar; which is really typed in as 2/5/2012 and 3/15/2012. My chart when graphed keeps showing the X-axis as 1-FEB and 1-MAR. How can I get the graph to show the x-axis titleas as 2-Feb and 2-Mar?
I've tried for some time now to create a chart where the x-axis make up for irregular dates. Making the line between 2 points longer if it's long time between them and short if it's short time between them.
I've finally understood line charts doesn't support that and I have to use scatter graph. It seems to work but the dates, the get all messed up. I type 2014-11-11 but the x-axis in the graph shows 2283-12-12 or something like that.
Got a notion that I might have to transform it to the date value manually first but I get #VALUE ERROR
i.e. 2014-11-11 in A1, then I type in A2 =DATEVALUE(A1).
How do I get a chart to work with irregular dates correctly?
HierLastRow shows as 165 in Locals which is correct. When I look at HierUID in Locals the Range is B2:B2 and not B2:B165. How can I make the Range set correctly?
I have a simple piece of code that creates a chart using the the values in column A as the x-axis and the values in column E as the y-axis. The values in Column A are all dates in this format: mm.dd.yyyy. However, when I collect the x-values they always appear as numbers (1,2,3). Even if I format the axis to Dates, they appear as 1.00.1900, 1.02.1901, etc.
Here is the code (also, I would like a VBA solution but if this is with excel's chart tools, so be it).
Code:
Sub Macro2() ActiveSheet.Shapes.addChart.Select ActiveChart.ChartType = xlXYScatter ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).Name = "=""Rate of Productivity""" ActiveChart.SeriesCollection(1).XValues = "='Sheet1'!$A$2:$A$4" ActiveChart.SeriesCollection(1).Values = "='Sheet1'!$E$2:$E$4" End Sub
I am trying to create a chart with dates from the past 6 weeks (one week at a time). The horizontal axis shows the dates from my data page correctly until I make one of the other data fields a secondary axis and then my dates change from the actual dates on the data page to 1-Jan-00, 2-Jan-00, through 6-Jan-00.
When I do the select data and look at the dats in the Horizontal Axis labels box, it shows the real dates. Why won't they show up on the chart as actual dates?
Using Excel 2007. Would like to format X-Axis values to display 1st month and 13th month as Feb 2, '08 for example. I would like the other 11 tick marks to remain. Sample attached ( Saved in 2003 format, I .xlsx was invalid file type) 4th micro chart uses F1:F13 for values for x axis
I want to draw a chart in Excel, in X axis Dates and in Y axis some other data. The dates which fall Saturday and Sunday will show in RED colour. Other dates will show in default colour.
I am working with the Ganntt chart and horizontal bar charts but can't seem to figure out a way to force the X-Axis to behave properly.
In Excel 2007, I am trying to get the X-Axis to show major units of Months. However, in my chart options I can only change the Y-Axis to be Date/Monthly.
Changing my data layout (from the below) to be a vertical format produces the same problem, just in the other direction.
My data looks as follows:
System Blocker Production Migrataion Retired
Sys1 1/1/2012 780
Sys2 1/1/2012 400 60 90
Sys3 2/1/2013 30 5 1
The Blocker column is formatted as "No Fill" in order to cover a portion of the time-scale.
My X-Axis displays as random dates throughout the period and all of my data displays properly in terms of the scale on the grid.
What is NOT working is that the dates shown on the X-Axis really need to be based on a Monthly scale instead of the randomly selected dates Excel is using.
20120823.xlsx
I can't seem to find the right combination of options to make that happen or force a scale on the X-Axis.
I have a spreadsheet with golfers handicaps, golfers names down the left in column A in rows 3-35. Row 2 has the event numbers titles 1 to 18 (18 events in a year). i need a graph that has the person as the vert axis and the horizontal axis needs to be the event numbers, so i can read down for the person and across to see how there handicaps change from each different event. i have attached the data below.
I have some numeric data that has to be put on a log chart. but there is no option for log charts. so i converted my data to log and then drew a chart but i am unable to edit the axis intervals and starting axis value. whenever i change the value it gets back to its default value,ie 1. can anyone tell me how to draw log chart or how to edit axis intervals and starting axis value?
how to incorporate another category and value axis to my existing chart.
1. I need to add a rank axis derived from my data column (C6-C15). This column should rank from highest to lowest and create a tie if any number is repeated. I have arranged the rank column in cells B38:L38 as they would appear. I would like this to appear on the top or bottom of the bar graphs.
2. Second I need to add the frequency of hits which = 3 derived from cell J1 This should appear on the chart were it is currently titled. This should create another bar graph colored green and labeled 3.
3. Lastly the numbers axis can remain the same as it appears on the chart or if it would be better to align as shown in cells B43:L43.
i had a situation where i import data from web.The sheet contains date & other columns.Whenever,i copy the data and paste it in my worksheet Using Paste Special >> Values i get some numbers instead of Dates.How would i correct the numbers to date format with out loosing the original date format(DD-MM-YYYY). Also the dates are aligned irregularly when i paste them to column.
How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in the X values. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. The line chart doesn't give me the ability to add the "missing" values, so it gives the impression that my data is more closely packed than it is. The data source is external to my spreadsheet, so I cannot add the values before creating the pivot table/chart.
creating a graph / chart using Ms Excel? I've been trying to do it myself but to no luck as I'm just a novice Ms Excel user. I'm trying to create a bar graph and combine with line graph based on these data. kindly refers to my attachment image for an example of desire graph. For line graph, it should display individually based on the given data. These are my daily data and I want to have an analysis graph so that I could monitor my computer's usage and its efficiency.
I am trying to combine 2 dates into the 1 cell separated by the word "TO:" So I have: =B2&" TO: "&C2 Which results in: 40211 TO: 40240 What I need is: 02/02/10 TO: 03/03/10
whilst trying to format a data series in the attached chart, i cannot find markers. on another chart when i format data series, patterns, i can edit lines and markers.
I got a set of data which is only 2 colums collecting data problems. The output i get is a time stamp and a fault. Im looking to set a chart up with the time been on the X - axis and number of problems per hour on the Y - axis.
I have some simple data and i want to create a horisizontal bar chart with 2 axis (X axis) the top one showing number of stocks number up to 270 and the bottom with Market Cap up to 1,200. (See attached). I set up the chart and it looks fine but it has only one axis so in order to create a second axis i right click on the blue series (no of Stocks) and go through the motions of setting up a secondary axis. However when i do that it ends up looking like the chart to the right with the Bars Cojoined (which is not what i want) I cannot seem to achieve 2 axis with separated bars
How to autoscale chart using VBA, so i can maximize the viewable area without using the default format axis on chart each time i paste new data to the table,
I am trying to create a column chart/graph with "Days Past Due" on the x-axis and "Quantity" on the y-axis. In other words, data from one column needs to make up the x-axis and data from another the y-axis where the bars will rise to meet that quantity. I was wondering if this is possible. I have not been able to find a way to make it work so far. I know there is a way to do it for a line graph through XY scatter, but I need a column chart.
Probably is in the wrong forum, let me ask a question to justify it being here. How can I force the y-axis min & max to be a particular number. If that isn't possible, how can I add a straight line to indicate the min & max?
How can I turn this into a dual axis chart whereby it shows the number of current stores open (like it does right now) as a bar chart. But also as a line chart shows the store potential (%) - so for example, PSUN has 960 current stores and has a 96% store penetration rate.
I would like to create a bar chart which is linked to a drop down box (from data validation) that allows me to choose of the 3 sets of data to show in the x axis.
So if i choose "HALF YEAR", the bar chart will have two bars (one is "jan-jul" the other is "jul-dec") with the green section data if i choose "QUARTER YEAR", the bar chart will have four bars ("jan-mar", "apr-jun", "jul-sep", "oct-dec") with the blue section data if i choose "INDIVIDUAL MONTHS" i have twelve bars....with the red section data.
