Data Not Create 3D Bar Graph?
Feb 26, 2014Data or a case that can't be created a 3D bar graph from? I've been told there is just a little of data that can NEVER create 3D bar graph.
View 2 RepliesData or a case that can't be created a 3D bar graph from? I've been told there is just a little of data that can NEVER create 3D bar graph.
View 2 RepliesI am trying to create a line graph that will incorporate multiple columns of data in one series of data. The reason I do not place all of the data in one column is because it could exceed the maximum amount of rows allowed in excel. Also I need the data split up for viewing purposes.
I can easily just graph one column but how do I combine all the columns into one line graph with the data being in separate columns. Basically all the columns will be my Y values and X values are just 1:n.
Example Below:
Column AColumn B Column C159261037114812
Now in the example all of the values are x values.
I'm looking to create a graph where the data source is two columns:
Column A (From A2 down to last but one populated cell)
Column ? (Last populated column on the right, from ?2 down to last but one populated cell.
all I have at the moment is the generic code for creating a graph (which I reverse engineered from a macro I recorded).
Code:
Charts.Add
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData Source:=Sheets("1_bth_x_wk").Range("A1:H40"), _
PlotBy:=xlColumns
ActiveChart.Location Where:=xlLocationAsObject, Name:="1_bth_x_wk"
I have used sumif statement to set up a value by week and then used the drop down list cell reference to display what i want ie week 25 data
What I would like is to display the 8 previous weeks and then use this in a graph, so every time i change the drop down week I see all the data showing the current week and previous weeks.
Now the problem is which formula do i use to to identify previous weeks
ie
WK No 21 22 23 24 25
Visits 100 200 250 300 400
Ok, so here's the trick:
I know how to create combo or mixed graphs with line/bars on single axis, and secondary axis. I even know how to do mixed stacked and unstacked columnar charts...
But how do you depict in single view graph
a single bar (1 datapoint) with a single line (upper control limit e.g. target).?
And I don't want to to use shapes to draw the target line.
I want the target line to be automatically plotted by Excel...
I want to do is use a userform to automatically create a graph from the data that is shown in the worksheet. The data in the work sheet will grow and shrink all the time. Am i right in thinking I am meant to create a dynamic range? I know how to do it but am not too sure what I am meant to be naming. And secondly I am not too sure how I set up the button to produce the graph.
View 4 Replies View RelatedI have a spreadsheet created in Excel 2003 (which is what we use at work, unfortunately).
My employees periodically take a test to ensure they have certain items memorized (or are making progress to that end). The spreadsheet rows show all 46 of my employees, and their test scores. The columns are the dates that the tests are administered. I can create a line graph based on the chart data, and interpolate these data with no problems.
The problem is that there are 46 employees! 46 lines on the same graph make for a very cluttered, hard to understand visual. I want to simplify the view by "filtering out" some of the data.
I have an additional column in my spreadsheet for each employee's work area (Area 1, Area 2, etc), and another column with data based on first letter of last name (the values here could be "A-G", "H-M", "N-S" and "T-Z", for example). I figure i could filter my line graph based on these two columns. For example, somehow select just Area 1, and reduce the number of lines on the graph to 16. Or better yet, Choose "Area 2" AND "A-M" and end up with 7 employees (and therefore 7 lines on the graph).
Here's what i have tried:
1) Select the work area column, and use the Filter, which created a drop-down list at the column heading. When i use this drop-down list, i can easily filter the data in the worksheet by Work Area, but this is not reflected in the line graph, which still shows all 46 lines. The problem was that i forgot that i had set the Calculation Options to "Manual". Setting this to "Automatic" (or leaving it on Manual and pressing F9) solved the problem, as the chart now updates when i use the filters. Calculation options are under the "Formula" tab in 2007, or in Tools -> Options -> [either calculation or formula, i forget what it's called] in 2003.
2) Create several separate line graphs in several separate sheets. I wouldn't want to assign someone else the task of maintaining a spreadsheet of such inefficient design.
Trying to create an N1.85 graph in Excel that has irregular spaced tick marks on the X-axis. Found the following information but no luck with it. Need US measure for this semi-log (10 X N1.85) graph. Also called a semi-expo (Q1.85) graph.
The resulting graph appears to be a log graph in reverse with one scale; the column widths are smaller at the left and become larger as they progress to the right.
Info found:
A 1.85 graph can be constructed manually by establishing a series of 15 values (in the case of the example in D5.2.1) from a base measurement to the exponent of 1.85.
Step 1
Select a base measurement for the desired size of the graph. A base measurement of 1.0 mm will produce a graph to 15 which is approximately 150 mm wide; a base measurement of 1.5 mm will produce a graph approximately 300 mm wide. In the case of a 1 mm base measurement, the x-axis numbers will be the 1-15 series. In the case of a base of 1.5 mm, the numbers will be represented by the series: 1.5, 3.0, 4.5, 6.0 etc. for 15 values.
Step 2
Construct a series of columns to the 1.85 exponent values measured from the zero point. The rows representing the pressure values are linear.
NOTE - A good approximation of the above can be computer-generated by a spreadsheet programme by entering a column width established from the exponential figures by subtracting the preceding value in each case. The column dimensions are displayed in the number of standard characters able to be accommodated in the column width which is slightly inaccurate in linear dimension.
The figures below indicate the values for a graph based on 1.0 mm.
Linear scale Exponential value of linear values = Column width = linear values to 1.85 power exponential value - preceding value
1 1 1
2 3.61 2.61
3 7.63 4.03
4 13.00 5.36
5 19.64 6.64
[Code]....
I want to create excel graph using VBA and found difficulties on chart name set to default.
the script is like this :
ActiveSheet.ChartObjects("Chart 31").Activate
Can I set my own name of the chart instead of "Chart 31" (excel default) ?
What can I have the IF statement return as a result that will NOT graph at all. Just leave a hole in the graph.
Long Question:
I have a large range of values and dates.
1/1 1/2 1/3 ....etc
10 11 7 .......etc
8 12 6 .....etc
These values are pulled via VLOOKUP() from various places. When VLOOKUP finds a blank cell, it returns a '0', which doesn't work for me. I've added an IF(ISBLANK), to return "", which is (I believe) an empty cell. The problem is, this is still graphing as a zero. So it will be graphing along nicely, and then shoot down to zero and back up again.
Rep NameCall StartedDuration h:mm:ssRep 12:19:18 PM0:00:36Rep 13:09:01 PM0:00:56Rep 13:11:01 PM0:01:05Rep 13:12:12 PM0:01:13Rep 13:26:26 PM0:00:39Rep 27:08:35 AM0:01:57Rep 27:16:32 AM0:02:12Rep 21:47:17 PM0:02:01Rep 37:05:01 AM0:10:37Rep 37:36:24 AM0:00:16Rep 311:41:43 AM0:15:21Rep 312:47:36 PM0:00:46Rep 31:45:36 PM0:02:19Rep 31:49:54 PM0:00:32Rep 31:51:46 PM0:00:56Rep 31:55:03 PM0:00:35Rep 31:59:26 PM0:00:22Rep 47:04:24 AM0:00:16Rep 42:40:41 PM0:00:08Rep 43:06:22 PM0:02:16Rep 43:21:35 PM0:00:04Rep 43:21:49 PM0:03:05
which is the time that any rep started a call and the duration of each call
and i need to make a graph from it that kind of looks like this:
(not actual data)
this way you can clearly see that for the most part rep 3 was the most productive however only rep 2 was on a call after 2pm.
i need this report to see tendencies on how much time is wasted on meetings and such keeping the reps off the phone.
How can I create a box chart showing graphically a median, 1st and 3rd quartile and a minimum and a maximum?
View 5 Replies View RelatedI am wanting to create a yearly graph, but it isn't allowing me to add cells from multiple worksheets.
View 1 Replies View RelatedI need to plot a stacked chart. I have attached a sample of it. I need to plot, category As X and subcategory and and its percentage as Y (stacked chart). In the attached sample I plotted a chart. The problem is, the series name showing is not correct. It takes the series name from the top row.
View 5 Replies View RelatedI have a table of data which contains company names, the number of high risk policies, number of low risk policies, and the percentage of high risk policies (compared to total policies).
What I want to do is for people to be able to select up to six of these companies and press a button that says 'create graph' and it creates a graph which shows the number of high risk and low risk in a stacked bar, and the percentage on a separate axis as a line. I know how to manually create this graph no problem, but to be able to dynamically create one from selected companies would be awesome.
To start with I have created six drop downs where you can select the company name as I image the macro will need to know which companies' data to look for in the source table.
I have a macro code that will create line graph referring the data given in defined column A1-C4,
Code with Static column range:-
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=Range("'Sheet2'!$A$1:$C$4")
ActiveChart.ChartType = xlLineStacked
I tried to modify the above code, so it will refer undefined/dynamic data column, but getting an error during execution "Run Time Error - 424:" "Object required"
Code with Dynamic column range:-
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=ActiveSheet.Range("a1", _
ActiveSheet.Range("a1").End(xlDown).End(xlToRight)).Select
ActiveChart.ChartType = xlLineStacked
Can I build/present a "Pie" chart DIRECTLY from a list of "ABC" letters WITHOUT counting the occurrence of each one of them and using the results [nor VBA / nor Pivot-Table] - which is the trivial way of building charts !?
An example of such a list will be:
A
A
A
B
B
C
C
C
C
C
I'm trying to create a line graph to show the trends of usage. I have a list of dates that I pulled from a website. I am trying to create a function that will count the number of dates between, for example, 8/5/2013 and 8/11/2013.
I had tried using this function to create a set of weekly ranges. =TEXT(DATE(2013, 1, 7)+(ROW(2:2)-1)*7, "m/d/yyyy h:mm AM/PM")&"-"&TEXT(DATE(2013, 1, 7)+(ROW(2:2)-1)*7+6,"m/d/yyyy h:mm AM/PM")
It correctly displays the date ranges, however when using this function:
=COUNTIF($E$2:$E$305, A2) Nothing gets pulled.
Here is one of the dates that has been pulled for example: 8/5/2013 11:10:00 AM
I am trying to create a graph where the date starts on July 1st and runs through a full year to June 30. No matter how I sort the dates in the cells, the graph still wants to start in January. You will see from the attached picture the very right lines up with the very left, where these should actually be meeting in the middle. as to what I need to do? Please see photo and dataset.
Chart.jpg
DataSet.xlsx
I want to create a dynamic line graph using week and year numbers stated in another sheet.
e.g.
Start Year - 2012
End Year - 2014
Start Week - 3
End Week - 12
The top 2 rows above my graph data are as below:
Year - 2012 2012 2012
Week - 5 6 7 etc.
This works fine if the start and end year are the same but if it's greater than one year, it doesn't recognise that.
Excel 2010 - I need to create a graph that shows a week's use of a sportsground showing what sports were played, on which days and between which times. I thought I could show the times on the vertical axis, days on the horizontal axis and then the sports played in those times, however I'm unsure as to how to get the graph to recognise the times.
I've attached an example of some data and how I'd like to see it, I'm just not sure how I can do this using the chart set up!
Attached File : Graphs.xlsx
I need to create a graph with a 2 x axis and a single y axis. For example:
Pressure ( PSIA) Solubility (mol %) Velocity (m/s)
200 0.024 1
300 0.036 1.2
400 0.041 1.8
I need the two x axis to be pressure and solubility and the y axis to be velocity, with the data being demonstrated by a single plot (I have only managed it with two plots which does not demonstrate solubility's relationship to pressure ).
For example at a pressure of 200 PSIA (lower x-axis) and solubility of 0.024 mol % (upper x-axis) velocity was found to be 1 m/s.
I would like to make a scatter graph that will graph the attached. The score would be on the Y axis and the birth date would be on the X axis. This is simple to do by itself but what I would like to do in addition to this is to have the top 25% of the scores a single color, the middle 50% of the scores a second color and then the bottom 25% of the scores to be a third color. And if it is possible to have the ID visible when you move your cursor over a given dot in the graph. Currently when I make a scatter graph the X,Y coordinates show when I hoover the cursor over a dot.
View 7 Replies View RelatedI was wondering, if I can extract data out of a excel graph what is been paste into word document and send to me, without the excel data sheet.
So I want to get data out of more then one graphs that are paste into word. and i want to do this in a fast way. In order to create a datasheets.
I am trying to create a graph for each store in my data sheet.
I have a data sheet with a list of stores that lists the quantity that was ordered by each store for the month of December. Not all stores placed ordered on the same dates.
What I would like to do is take the data from store line and create three columns that are: ....
I need to map the names of the companies on the x axis (ANF, AEO, ARO, PSUN) and 5% to 30% on the y axis. Plotted for each company should be the min and max. So two points for each company. How can I plot this data. Underlying data as follows:
MINMAX
ANF18.6%19.8%
AEO7.8%21.0%
ARO6.2%9.0%
PSUN6.1%14.2%
I work on graphics which show financial data. The base is day data together with calculated added values the graphic worked and showed good pictures.
But now I encountered a problem with the graph - related to not listed days, points are "generated" which do not be in line with the rest of the data !?
EXCEL_Forum_20140118.jpg
I am trying to graph the amount of calls that come in on each day and at what hour. I am trying to put the days of the month along the x axis and hours along the y axis. I then want the number of calls to show as a scatter at certain times on each day. Is this possible? I have attached a sample of a table I will be working with that has made up data on it. I have tried using the select data function to try and change the axis, but I do not think I am writing the correct things in.
View 4 Replies View RelatedI've created two large historical tables on separate sheets. The master sheet (Bins) contains the following columns:
Year - Side - Commodity - Variety - Block and then each consecutive column is a day of the year, starting at 4/26 and going through 10/31 (F - GL). Column GM is a sum of all days in each row.
For example, GM15 totals F15:GL15. The second sheet (Percentages) is identical to the first in size and format, however, it calculates daily percentages of totals from the first sheet. For example, cell BA15 contains the formula
Is it possible to plot an xy scatter graph of "Result A" versus "Result B", and have the data points labelled with the values under "Mix" ?
Mix Result AResult B
1340.543 0.520
1360.562 0.525
1380.570 0.526
1400.561 0.528
1410.559 0.526
1420.568 0.526
1440.570 0.526
1460.578 0.526
1470.579 0.530
1480.575 0.529