Excel 2013 :: Date On Horizontal Axis On Chart

Apr 12, 2014

I'm having trouble getting the dates i want on the horizontal axis on a chart in Excel 2013. I want 12 dates along the axis starting at 01/01/2013 then each month until 1/12/13 however as you can see the dates are 01/01/1900.

View 10 Replies


ADVERTISEMENT

Excel 2007 :: Dates By Month On X-Axis In Horizontal Stacked Bar Chart?

Aug 24, 2012

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.

View 1 Replies View Related

Create Chart With Names In Vertical Axis And Values In Horizontal Axis?

Mar 1, 2014

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.

View 1 Replies View Related

Excel 2003 :: Labeling Horizontal Axis Of XYScatter Chart With Math Division Inverse

Jan 16, 2013

We make many graphs using XYscatter charts with lots of data points using Excel 2003 with the horizontal scale properly scaled as frequency. I have been asked to label that axis in some way as period (=1/frequency) without changing the scaling for the data plot. Is there a suitable way to do this? It would be OK to just change the axis numbers to 1/frequency computed from them automatically. Is Excel 2010 any easier for this?

View 9 Replies View Related

Horizontal And Vertical Chart Axis As Value Axis

Jan 26, 2008

What is the best way to have both horizontal and vertical axis as value axis?

View 2 Replies View Related

Chart Dates On Horizontal Axis

Oct 31, 2012

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?

View 2 Replies View Related

Excel 2010 :: Cannot Change Chart X-axis To Display Date Values

Nov 27, 2012

Example attached : Copy of CAB.xlsx

View 2 Replies View Related

Excel 2007 :: Horizontal Align X Axis Title To Plot Area VBA?

Jun 16, 2012

We have a lot of charts we want to create in Excel 2007. We have templates created that seem to work. (But also sometime seem to not.)

After the charts are created that are placed in their own chart pages/sheets. The problem I'm having is that the x axis title doesn't seem to be centered horizontally wrt the x axis of the plot area. (It does look centered wrt the chart area.)

Some code or an algorithm to control he placement of the x axis title and maybe center it?

View 9 Replies View Related

Excel 2010 :: Horizontal Axis Labels Not Updating Range - Have To Update It Twice To Stick

Jan 28, 2013

I recently switched to Excel 2010 and have a rather peculiar problem.Every week I update a bunch of charts in different workbooks. By update, I pretty much mean just shifting the range over one column or down one row to incorporate newly added data.

So I right click the chart, select "Select Data", update all the Data series ranges and then I click on the Horizontal (Category) Axis Labels button "Edit" to update the Axis label range.

I do all that then press OK. The data series have updated, but the axis labels haven't. So then I do the procedure again for the Axis Labels, hit OK again and voila: It worked.

But I ALWAYS have to do this procedure twice. It will NEVER update the axis labels the first time around. Even though the little preview window below the edit button show the labels correctly.

View 1 Replies View Related

Chart Axis Date Intervals

Feb 20, 2009

I'm using Excel 2007 and I want to plot data vs dates. Furthermore I want the dates on the dates axis to increment by month not by a certain number of days. So something like this:

1-Jan-09
1-Feb-09
1-Mar-09
...

There's the Major/Minor Units on the Axis Options screen but I cannot type in a constant number since the number of days for each month is different.

View 12 Replies View Related

Excel 2003 :: Add Horizontal Line To Stock Chart?

Feb 25, 2011

I am using the the stock chart and I would like there to be a horizontal line across the chart with a y-axis of the opening price. In the end I want this to be in VBA but how to do this manually I should be able to put it in loop of data that will produce many charts with a horizontal line starting at the day opening.

I have tried to add a new series to the chart but I'm using the Candle stick stock chart and the new series comes out as a vertical not horizontal line. I read about using a secondary horizontal axis but all the tutorials I find are in Excel 2003 and they donlt line up well with Excel 2007.

I found this link on charts with horizontal lines but again they are in 2003 and I'm using a candle stick stock chart not a scatter chart. [URL]

View 6 Replies View Related

Excel 2010 :: Adding Horizontal Line In Chart?

Oct 11, 2011

I want to a horizontal line in a chart. There are only two figures with me. One I want to display as a column chart. The other as a horizontal line chart. (I can use both excel 2003 or 2010, whichever is suitable)

View 2 Replies View Related

Excel Chart - Defining X Axis Value

Mar 15, 2013

Excel chart that whenever I am defining than X axis value then excel chart will show 2 unit more than whatever is my maximum value.

View 3 Replies View Related

Stacked Chart - Change Bar Colors Based On Date (X Axis)

Apr 19, 2014

I am wanting the colors of the bars in a stacked chart to change based on the date in the X Axis. As the current date arrives, the stacked bar needs to change to various blue shades. If the date is in the future, the stacked bar needs to be various grey shades.

View 2 Replies View Related

Gantt-type Chart With Quarterly Marks On The Date Axis?

May 22, 2014

I'm using a stacked bar chart (in Excel 2010, running on Windows 7) to create a simple Gantt-type chart - with just four or five bars. I've got my chart looking most of the way I want it to, but one thing still eludes me: I'd like to set up the major axis ticks to be quarters of the year (from 1/1/2011 to 4/1/2013). Since quarters are not regular intervals (they are not exactly every 90 days), I can't do this using Excel's standard functionality for choosing axis tick marks.

View 3 Replies View Related

Dates With Different Colour In X Axis In Excel Chart?

May 12, 2013

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.

View 7 Replies View Related

Excel 2013 :: Chart Label Not Displaying?

Jun 8, 2014

I have a workbook, which I use for different departments that displays a number of different pie charts and I have found that a particular pie chart omits a specific label repeatedly. The pie chart displays the wedge within the chart itself, but does not display the label. At the moment I have data labels with percentages. All other labels display, of which there are 7. I found a solution that fixes the problem each time it arises and that is to select Chart Tools/Format/Series 1 data labels and then Format Selection. When I then select any data label, I click on "Clone Current Label" and the missing label appears with the correct percentage amount. I use the workbook for multiple uses and rather than have it present as a template (*.xltm), it is a macro-enabled spreadsheet (*.xlsm). Could this be related to the problem?

View 2 Replies View Related

Removing Percentage Sign On Excel Chart Axis?

May 21, 2014

I realize all the numeric data was originally not in percentage format (a simple division without being multiplied by 100). So when I set the vertical axis to percantage format, it does display it as a percentage but with the "%" sign. Is there any way I could get rid of the sign? It's not necessary as the axis has already been titled accordingly. I'd hate to redo all calculations, multiply by 100 and then create new charts only to get rid of the sign...

View 1 Replies View Related

Excel Pie Chart - Unable To Use Sums For Fields / Axis?

Aug 4, 2014

I have a set of data for hours of work. I want to make a simple Pie Chart: % of Hours worked overtime, and % of work not overtime.

The Data Looks something like this:

Name,Normal Hours Worked, Overtime Worked
David,8.0,3.2
Anne,8.0,1.3
Danny,7.0,0.0
Harry,8.0,3.0
Edward,8.0,2.3

So I want a pie chart that has 2 wedges.
~25% labeled as overtime worked
~75% labeled as normal hours worked

Whenever I put these values in the pivot table and use SUM, it is trying to sum based on # of hours matching, instead of by the column Name... so it gets divided into a bunch of different pie wedges.

View 2 Replies View Related

Excel 2010 :: Formatting Chart Axis Values?

Oct 8, 2011

Why the recorded code doesn't work? I recorded the code below to format the Y-axis values of a chart with the recorder.

Code:
ActiveChart.Axes(xlValue).Select
With Selection.Format.TextFrame2.TextRange.Font
.NameComplexScript = "Arial"

[Code].....

View 6 Replies View Related

Excel 2010 :: Y Axis Stuck In Middle Of Chart?

Feb 10, 2014

I have a bar graph in excel 2010 and the vertical access is stuck in the middle of the graph. When I right click on the axis and select "format axis" I have an option to set where the horizontal axis crosses but never the vertical.

View 1 Replies View Related

Excel 2013 :: Plotting Gaussian Curve Over Bar Chart

Apr 14, 2014

I'm trying to overlay a Gaussian distribution on some data. The data is a frequency of particle size diameters, ranging from 200-1000 um (see attached). I'm using Excel 2013.

View 1 Replies View Related

Draw Log Chart Or Edit Axis Intervals And Starting Axis Value

Apr 20, 2007

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?

View 6 Replies View Related

Charts - Horizontal Axis

Jan 26, 2009

I recently started keeping a new chart to track several different stocking measures. After running the data this morning, I noticed my horizontal axis had blank position holders for data over the weekend. How would I set the chart so that if there is no data in my data range, it doesn't put a place holder in the axis? Sample attached.

View 4 Replies View Related

Excel 2010 :: Place Textbox Between X Axis And Bottom Border Of Chart

Oct 27, 2011

In Excel 2010 I need to place a text box between the X axis and the bottom border of a chart.

How can increase the white space between the X axis and the bottom border to allow me to do this?

View 1 Replies View Related

Excel 2010 :: Color Chart Secondary Axis Remains Black

Nov 26, 2011

All I want to do is color the numbers on both the primary and secondary axis. Primary i want the shade of blue below. Secondary I want the shade of green below. Only the primary axis part of the code does its job. The secondary axis remains black. The code does complete without errors. Excel 2010.

sub color_axis()
ActiveChart.Axes(xlValue).TickLabels.Font.Color = RGB(38, 40, 118)
ActiveChart.Axes(xlSecondary).TickLabels.Font.Color = RGB(0, 153, 0)
end sub

View 1 Replies View Related

Horizontal Category Axis Label?

Mar 11, 2014

I have a chart and a number of the data sets have a horizontal data but then some sets don't. How can I add the same horizontal data to the sets that don't?

View 1 Replies View Related

Plotting With Words On Vertical And Horizontal Axis

Apr 29, 2014

I am tasked to plot some client satisfaction data on a monthly basis. I want to be able to show the client satisfaction with different aspects of service delivery. Can have a chart with "Good", "Fair", and "Poor" on the vertical axis with months on the horizontal axis?

View 1 Replies View Related

Second Category Axis & Value Axis To Current Chart

Sep 27, 2006

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.

View 5 Replies View Related

Sorting Horizontal Bar Graph With Y Axis In Alphabetical Order

Feb 28, 2012

I need to sort a horizontal bar graph, with the Y Axis in alphabetical order.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved