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
ADVERTISEMENT
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
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
May 23, 2014
I have an excel which creates PPT from the excel. but the graph pasted in PPT are not aligned and formatted.
By aligned, i mean re-size the graph and paste in a formatted fashion (currently they are overlapping each other)
My entire PPT created is off alignment and formatting. E.g heading are not properly aligned (they are touching the line below) and so on.
View 1 Replies
View Related
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
View Related
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
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
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
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
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
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
Nov 27, 2012
Example attached : Copy of CAB.xlsx
View 2 Replies
View Related
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
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
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
Jan 26, 2008
What is the best way to have both horizontal and vertical axis as value axis?
View 2 Replies
View Related
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
Aug 27, 2007
The issue is that for every pivot table in any file running on my machine, I am unable to drag the column or row values to change the sort order - I.e. if the row is Jan/Feb/Mar/etc., I can't drag Jan down to the middle or rearrange them - it will sort by ascending or descending value just fine, but simply won't allow me to rearrange - the 4-way arrow doesn't appear where it should when mousing over the fields. I can drag fields on/off and from/to the column/row/data sum areas, but I simply cannot re-arrange the order of the values (and yes, the Autosort checkbox is set to "manual" in field settings.)
View 7 Replies
View Related
Nov 6, 2013
I have a pivot table/chart that I need to show the sums as top 20 (or any other number) and All others. How can I do this.
I have an example file here: [URL] ...........
View 4 Replies
View Related
Apr 18, 2013
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.
View 1 Replies
View Related
May 13, 2014
I've put together code to construct a chart
It all works fine but I've noticed an odd quirk which I can't explain nor can I seem to fix. Here's the (reduced) code :
Code:
Dim appExcel As Object ' Excel Application
Dim chtPareto As Object ' Chart
Set appExcel = CreateObject("Excel.Application")
Set chtPareto = appExcel.Charts.Add
With chtPareto
' Primary category axis
[code]....
The category (x) axis title should be horizontal, whereas the value (y) axis title should be rotated. Stepping through the code, when I .SetElement for the category axis title, it appears horizontal as planned. However, as soon as I .SetElement for the rotated value axis title, the category axis title also rotates.
View 3 Replies
View Related
Aug 1, 2007
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.
View 7 Replies
View Related
May 17, 2007
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
View 3 Replies
View Related
Feb 21, 2014
I had a couple of days ago..
I can get the "Daily %" to update just fine but for the life of me cannot get the "Total Number of Patients" to update.
View 3 Replies
View Related
Apr 7, 2014
a_Y-Axis auto scale.zip
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,
View 5 Replies
View Related
Aug 13, 2002
I would like to make a graph with an x, y and z axis. All of the choices that excel gives me are only x,y graphs. How can I plot a 3-axis graph?
View 9 Replies
View Related
Jun 5, 2012
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
View 4 Replies
View Related
Jan 4, 2008
i want 0 values to start at x and y axis.
basically i want time in secs on x axis starting a 0 upto 4.4 secs
View 9 Replies
View Related
Apr 16, 2008
I have a dataset that looks like this ....
View 9 Replies
View Related
Jun 30, 2006
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.
View 6 Replies
View Related