Chart/Graph For Individual & Group Totals

Aug 20, 2008

I am working on the evaluation of a survey. I had 212 respondents which could be divided into three distinct groups. I would like to present the results of a question in columns that reflect the total frequency count in percentages. At the same time I would like those columns to be stacked in order to illustrate the contribution each group has made to that particular answer. I have attached an xls file with the data and a demonstration of the outcome I am trying to achieve.

I haven't been able to create the graph so that the columns display the total count in relation to all respondents on the one hand and at the same time are broken up into the individual groups. Among others, I have read the thread: http://www.ozgrid.com/Excel/stacked-column.htm but that doesn't answer my question as the Total there is actually the cumulative total of the other values.

View 5 Replies


ADVERTISEMENT

Insert Blank Rows At The End Of The Each Data Segment To Add Totals For Each Individual

Sep 2, 2007

I need to insert blank rows at the end of the each data segment to add totals for each individual. Is there a macro that I can use for this? I'm attaching an example file.

View 8 Replies View Related

Color Individual Lines Of Shape Group

Feb 3, 2008

The group behaves as one shape alright when, say, coloring the line, but is not "fillable". Below a simple sample. - The custom shape i am trying to color in is not a simple square or rectangle -not anything from the existing MS shapes that is....

View 6 Replies View Related

Making Single Graph With Two Datasets That Have Individual Dates

Apr 3, 2014

I want to make a single graph from two data sets that have individual dates.

help!.xlsx

E.g.
Data set 1
1. January 2010 2. january 2010 ... 10. december 2010 etc
10 15 ... 10 etc

Data set 2
1. January 2010 ... 1. January 2015 etc
200 ... 200 etc

View 8 Replies View Related

Create Individual Worksheets For Each Related Group Of Table Range

May 25, 2008

I have a huge worksheet containing Blackberries expenses of my company divided by multiple sections. Each section follows the following pattern: Example:

Client 222-5555 MY COMPANY NAME LCC
International Calls
- Call to Bahamas on June - $50,00
Local Calls
- Call to NY on June - $ 30,00
Total Price - 80,00

I would like to select each row between client and total price and paste then on multiple sheets in order to create individual invoices. The selection must be based on the client number (for instance 222-5555) that is part of the cell value.

View 4 Replies View Related

Excel 2003 :: Filter Data In Graph / Chart (without Having To Create New Chart)

Dec 29, 2011

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

View 1 Replies View Related

Graph Composition Of Group Over Time?

May 30, 2012

I want to graph the composition of a group over time. I want to create an area graph, where you can see what kinds of things were in the group at any given year . There are, let's say,three categories of things: A, B, and C - and I have the purchase and sale date for each.

View 2 Replies View Related

Group Column Bars In Graph With Specific Sorting?

Jan 7, 2014

I'm trying to figure out a way to group columns in a bar graph without displaying them in a cluster, but instead in displaying them individually in a specific order. However, I still want to identify each group with a different color. This is hard to describe, so I'll try my best to illustrate what I'm trying to do with an example. Assume I have three groups of data and within each group I have 2 to 3 items in it with different values. In a list the data would look like this:

Group 1 - Item 1 - $2,000
Group 2 - Item 2 - $1,100
Group 1 - Item 3 - $2,200
Group 1 - Item 4 - $3,200
Group 3 - Item 5 - $1,800
Group 2 - Item 6 - $1,200
Group 1 - Item 7 - $2,500
Group 3 - Item 8 - $2,800

What I want to do is create a bar graph that will still allow me to color all group 1 items as red, all group 2 items as blue, and all group 3 items as green while still showing each bar sorted in the order I've shown above and labeled as items 1 through 8. Then, I want a legend to only show the groups 1 - 3 with their colors. To explain, the graph would look like this:

Bar 1 would be labeled as Item 1, with a value of $2,000, and colored red
Bar 2 would be labeled as Item 2, with a value of $1,100, and colored blue
Bar 3 would be labeled as Item 3, with a value of $2,200, and colored red
Bar 4 would be labeled as Item 4, with a value of $3,200, and colored red
Bar 5 would be labeled as Item 5, with a value of $1,800, and colored green
Bar 6 would be labeled as Item 6, with a value of $1,200, and colored blue
Bar 7 would be labeled as Item 7, with a value of $2,500, and colored red
Bar 8 would be labeled as Item 8, with a value of $2,800, and colored green

Then, the legend would only show the groupings of Group 1, 2, 3, 4 and their associated colors.

(By the way... I know I can do this manually by selecting each bar and customizing the color, but I want an automated way of doing this to reduce maintenance time)

View 1 Replies View Related

Graph Lines Disappear When Group Or Hide Data

Mar 11, 2014

I have a file sheet named "ratio summary." The data to this is linked to a number of different working sheets (not in the attachment for obvious reasons)

Currently the data in the ratio summary is grouped by year but "open" and the Graph worksheet is automatically linked to the data in row11.

However when I group the data by year (i.e. clicking the "-" figure) the graph also changes.

I haven't deleted the data so don't understand why the graph data is changing.

excel graph help.xls

View 3 Replies View Related

Information Dissapears From Graph When Section Of Other Sheet Is In 'group'

Sep 29, 2009

i dont know if there is a way around this, i have a sheet, it has one large sheet with hundreds of rows under 3 headings, and i have a group on each of these so people can go in and expand their section and add details, i have a second sheet that contains some graphs simplifying the data collected in the 3 sections of the other sheet..

but i have just noticed when a section of the sheet is grouped its details are removed from the graph.

is there any way around this? i need the groups on as the sheet is so big and people do not want to be scrolling through other area's data when they can just expand their own.

View 4 Replies View Related

VBA Needed To Make Separate XY Scatter Graph For Each Group At A Time And Must Be Unique

Aug 19, 2014

I have 5 different groups for that i have to make XY scatter graphs and my data looks like this

XY
125
13
156
145
134
234
248
260
2102
2105
3125
3148
3198
3298
3245
4386
4369
4234
4465
4898
5902
5907
5345
5234
5209

now i want to make 5 different graphs one per each group. Now i am making them manually in excel but it is taking lot of time to format each graphs to get unique graphs. I am attching sample file and graph for better understanding.

View 3 Replies View Related

Set Transparency Of Individual Chart Points MAC

May 16, 2008

I have a VBA script that walks through the series of points on a chart and sets color based on other parameters unique to each point. Unfortunately, this doesn't see to work.

Running the following code, the .MarkerBackgroundColor and .MarkerForegroundColor commands seem to have no effect:

With myChtObj.Chart.SeriesCollection(1).Points(Counter)
.MarkerSize = 8
.MarkerStyle = xlDiamond
.Shadow = True
.MarkerBackgroundColor = RGB(250, 250, 250) ' These have no effect
.MarkerForegroundColor = RGB(0, 0, 0) ' These have no effect
.MarkerTransparency = 0

End With

Setting these parameters for the series as a whole does work, but not for individual points. Is this a known issue? Is this unique to the Mac version of Excel?

View 4 Replies View Related

How To Control Individual Functions In Excel Chart

Apr 13, 2014

All of the functions' X Axis were given the same data (12,24,36,48), except ROULETTE and TOURNAMENT which were also given (60) for the X axis.

Why do the NORMAL bars aren't located on the place they should on the X axis?

For example, the 1st bar (from the left), should be a little more to the right. The others should move to the left.

View 1 Replies View Related

Scaling Individual Axis On Radar Chart?

Jun 10, 2014

I'm trying to use a radar chart with six variables, they range from 1.8 to around 23; obviously this doesn't present very well on the Radar graph; how to format and scale each individual axis?

View 1 Replies View Related

Adjust Height For Individual Column In Chart?

Aug 15, 2014

Refer to enclosed excel file, I have drew a chart base on the data in side. However, for the last column which is "SG Productivity(KUSD)", The column very small even cannot be seen, is there any way can enlarge columns in this field without changing other column? T

View 1 Replies View Related

Stacked Column Chart Totals 2007

Jun 28, 2008

Would like to add totals to stacked column chart in Excel 2007.

I have followed same steps listed here [url] but cannot position data labels above column.

Excel only gives me the options Center, Inside End, and Inside Base.

I also tried setting label position with VBA:

For Each co In ChartObjects
For Each s In co.Chart.SeriesCollection
If s. Name = "Totals" Then
For Each dl In s.DataLabels
dl.Position = xlLabelPositionOutsideEnd
Next dl
End If
Next s
Next co

Also tried the following without luck:

dl.Position = xlLabelPositionAbove

For each VBA example I get following error:
Run-time error '-2147467259 (80004005)':
Automation error
Unspecified error

It seems like Microsoft has removed this positioning option for stacked column charts because it works fine for normal column charts. Anyone find a way to do this otherwise?

View 9 Replies View Related

Graph The Following Data In An Area Chart With Line Charts Superimposed On The Area Chart

Nov 1, 2006

I am trying to graph the following data in an area chart with line charts superimposed on the area chart. I have a lot of data (and a lot going on) so I'm trying to figure out the best way to show this in excel from a functional standpoing (i can't get this to work in excel!!) to also an asthetic standpoint (dont want it to look terrible or illegible). This is what I'm trying to chart:

1) Weather data (temperature) by region:
So one region, would be: Northwest
I would like the "area" (so a shaded region) to be the min/max of the temperature data for each month.

2) I would like to show the temperature for each year as a line graph on the chart - so you can see if a year falls in or out of the shaded region.

3) I would like to show a company's sales increases across the same months per year as separate line charts. I may choose to just show the biggest outlier year in the end... or to show 2006 (the latest data).

What I am trying to convery with the chart is that the company's sales is or is not tied to weather deviations. I have attached an excel file with the data. I haven't been able to use the area chart or get a two axis chart to work or get it to look even remotely professional.

View 3 Replies View Related

Excel 2007 :: Creating Attractive Cumulative Totals Chart?

Oct 22, 2011

I'd like to use two columns / labels to create a colorful bar chart that just piles each field value on top of each other and shows the amount (and percent of total if I can) along the first column's values next to the bar chart something like below..

So column 1 is the "entity name" and column 2 is the "value/amount".

I can't make this chart look right at all. I have Excel 2007.

View 4 Replies View Related

How Do I Not Graph A 0 Value On A Line Chart

Oct 26, 2009

I have created some charts for my work and one of them is a line chart that spreads across one year with values for each month. Well they want the graph to always show one month ahead of where we are out. So there is actuals in for Sep. but then the line graph drops all the way to 0 for Oct. I don't want to have the graph bottom out when there is a zero. Does anyone know how to fix this?

View 9 Replies View Related

Graph-Chart In Cell

Dec 18, 2006

I was tracking down simple ways to generate ASCII character based bar charts and came across this stunningIncellBarChartExample where the author suggested this can be done using VBA code.

I am very new to Excel and EXCEL VBA. Can someone help me sketch how the coding for the above example (include mixed colors) might be done? Is there a special font that need to be used?

View 3 Replies View Related

Chart Or Graph Percentages

Sep 11, 2007

I need to plot percentages over time in a line graph in excel. I don't want to have to do a percentage equation in the spreadsheet, I just want excel to take two sets of values and display the percentage in the chart. For example, I need B1 as a percentage of B2 for week 1, C1 as a percentage of C2 for week 2, etc....

View 3 Replies View Related

Create Box Chart/Graph

Mar 12, 2008

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 Related

Rotate Chart/Graph

Apr 23, 2008

is it possible to rotate a graph. i need to turn my stacked cone graph upside-down so that the point is facing down and not up

View 2 Replies View Related

3D Chart / Graph With Spherical Coordinates

Mar 1, 2008

Is it possible to create a chart using spherical coordinates (radius, theta, phi) in Excel? I want to create something similar to this. I would even be willing to write add-in code to create the graph from scratch, but I don't know if that's possible. Is it possible to create a new chart type without using the other chart types as a base?

View 5 Replies View Related

How To Plot 2 Chart Types On One Graph In VBA

Apr 14, 2014

I would like to create a chart in vba which contains 2 sets of data, both using the same x axis. The first must be a line graph, the second a staggered bar chart. This must be represented on one chart with data labels. Also, how do I change the colour of the plots?

View 5 Replies View Related

Drop Down Chart To Run A Graph Macro

Mar 6, 2007

I am trying to figure out how to activate a macro from each item in a drop down list. I also need the macro to recognize which item is chosen and to use that items data (say cells C3:C11) to create its graph. I know how to create an individual macro that will create a graph for the item but not a general macro that can be used to graph all items just discerning the difference in where the data is (which item to graph). Is this possible????if so please include code (amatuer programmer).

View 9 Replies View Related

Graph Bell Curve Chart

Jul 14, 2014

I'm trying to graph a bell curve chart using the following data

Hotels per state
Total

AK
4

NH
5

[Code] ......

As you can see I have states and the number of hotels per state what I need not for statistical purposes but more for "pretyness" is to sort this data in a way that what you get is a somewhat of a bell shape curve graph.

View 2 Replies View Related

Rolling X Month Graph Or Chart

Aug 15, 2008

I've been working on this for a couple hours and I am close to getting it how I want. Basically I want to have a rolling 15 month graph that will change according to the month you choose in the drop down tab. Example: I choose july 2007, the graph will show data from july 2007 to September 2008. I have the graph functioning, however my formulas are off (collecting the wrong data). I've included a spread sheet

View 2 Replies View Related

Not Plot Zero Values On Chart/Graph

Oct 20, 2006

one of my excel reports, i am using a dsum formula and plotting a chart against it. i do not want to show the zeros on the graph, is there anyway i can do that, i could not find anything in the tools -> options.

View 2 Replies View Related

Automatically Update Graph/Chart

Mar 17, 2008

I have a macro that extracts data from a source workbook. The data is owerwritten every time that I use the macro. Now I have a graph that everytime I use the macro does not update with the new data, Is there a clever way to do that? The code for extracting from the workbook is the following:

Sub Extract()
Dim myFileName As Variant
Dim SourceWkbk As Workbook
Dim CurrentWkbk As Workbook
Dim testWks As Worksheet
ActiveWorkbook.Sheets("CURRENCIES").Select
ActiveWindow.SelectedSheets.Delete
myFileName = Application. GetOpenFilename("Excel files,*.xls")
If myFileName = False Then
Exit Sub 'user hit cancel
End If................

View 4 Replies View Related







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