Making Chart/graph From Text By Occurrence

May 29, 2009

I track inventory/sales for a very small sole proprietorship. I'm looking to track the number of items that I sell based on the text that I enter in a certain column.

Specifically, I want to have a visual chart/graph to show the percentage of each size/color of an item that I sell, as I sell it. When I enter the words "3T pink" I want the chart/graph/whatever to show another quantity of this category. As I sell a new item, I want the chart to reflect it.

The problem I'm having, is that the graphs/charts require two data sets, but I want the graph to calculate it for me! All I want to do is enter the text for specific items, and when the text occurs subsequent times, I want this reflected in the graph/chart.

It seems so much more simple in my head....basically I want a dynamic chart, not based on a static data set.

ADVERTISEMENT

Create Chart/Graph From Text Strings

Apr 25, 2008

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

View 9 Replies View Related

Making A Trend Graph With Multiple Values?

Jul 17, 2014

I was asked to make a trend graph showing activation's and deactivation's over time. My boss wanted it to be done automatically when you placed values into a simple excel sheet like the attached image (the graph would be below this).

View 14 Replies View Related

Chart Making- Chart With 3 Data Series

Jun 30, 2008

I have a chart with 3 data series. The series are located in columns A, B and C respectively. Series I is a general number anywhere from 0 to 100,000. Series 2 is also a number, but is is devided by series 1. So, if series 1 was 100,000 then series two would be 25,000/100,000 which is 0.25. Series three will always be numerator of series 2 or 25,000 in this example. The numerator, or the 25,000 will never change, so, in my example, series three will be a straight line across the chart because it is always 25,000.

In my example, the .25 is plotted on the left value axes, and series one is plotted on the right value acccess (secondary axis). Series three is just a line in the middle.

My problem is that sometimes the line, series 3, doesn't match the values in both the right and left values axes. So, if series one is 48,000, then series two would be 48,000/48,000 = 1, and series three would be 48000 - the straight line. The third series should be a line touching the 48,000 on the right and the number 1 on the left. It does touch the 48000 on the left, but is below the number 1 on the left.

View 9 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

Excel Sine Wave Graph/function Making

Feb 15, 2010

i have some numbers as data, i want to find the function that generate thiese numbers and also i want to view the chart of it, its kind of sine wave graph.

View 9 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

Chart: Sorting Values In Accordance To Occurrence

Jun 9, 2008

I have a huge set of data values given per 0,5 hour. Now I want to make a chart which shows how many hours each value has taken place.

Here is what it looks like with the arranged data as y-values. Instead of the x-axis showing the number of values, I would like it to show the above mentioned.

View 14 Replies View Related

Making Chart With X / Y And Z Axis?

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

Making A Simple Chart

Jun 1, 2009

Im trying to create a bar chart that contains required hours per week with a line of hours worked going across the bars, im struggling to make this work and have basically no experience of making any sort of charts or graphs.

I need to create this using vba but to begin with I cant even make the chart manually! Where its all going wrong is the column line for required hours is so thin it looks rubbish. Its a bar chart then I formatted the series of total hours to be a line chart.

View 9 Replies View Related

Making A Special Chart

Jun 28, 2006

I want to make a chart in Excel similar to a Stacked Horizontal Bar Chart, except I want to be able to have spaces in between the bars of each row. I want to be able to have the separate bars represent spans of time, and I don't want them all to have to necessarily connect to one another. I tried the Floating Bar Chart under the Custom Types tab, but that doesn't let me have more than one bar per line (as far as I can tell).

View 2 Replies View Related

Making Chart Series Dynamic?

Jun 6, 2012

I am looking for a quick way to create a number charts using data from multiple sheets.

I have 12 sheets Apr - Mar that contain data in identical format. I also have sheets 12 sheets Apr Charts - Mar Charts, I need to create a number of charts on each sheet for the relevant month. To avoid having to create a ridiculous number of charts, I thought I would try to dynamically change the chart data series based on a value in say cell A1.

For example if cell A1 of the Apr Charts sheet = Apr, the chart will show the data for Apr.

The idea is that I can copy the Apr Charts sheet the required number of times and replace the value in A1, and my charts will update dynamically. I need to have seperate sheets for each of the monthly charts.

View 1 Replies View Related

Making A Chart From Data On A UserForm

Jul 26, 2006

I'm trying to make a chart (which will also be on the UserForm) from data that a user will enter onto a UserForm. The problem is that I am trying to select a data range as one of the charts 'series' but I can't quite find the right code. At the moment it looks like this:

ActiveChart.SeriesCollection(1).Values = Range(BMIM20Ttl, BMIM2025Ttl, BMIM2530Ttl, BMIM3040Ttl, BMIM40Ttl)
ActiveChart.SeriesCollection(1).Name = " Total"
ActiveChart.SeriesCollection(2).Values = Range(BMIM2075, BMIM202575, ...

The problem is with the Range function.

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 2010 :: Making Chart Title From Cell Contents?

Jan 10, 2014

I am trying to make the contents of a cell into a chart title.I know I can do it like this...

ActiveChart.ChartTitle.Select
Selection.Caption = "=tab_name!R2C1"

However, I am trying to use the same macro on several different tabs in the same EXCEL worksheet. Obviously, I can't have the tab name in the macro. But, I don't get a title at all when I try to remove it like this...

ActiveChart.ChartTitle.Select
Selection.Caption = "=R2C1"
or
ActiveChart.ChartTitle.Select
Selection.Caption = "=A2"

Is this possible? I am (kinda new at) using EXCEL2010.

View 3 Replies View Related

Making Chart Plot Data Cells & Not Null Values

Sep 6, 2006

I have a chart that shows up to a list of 28 people and the number of sales for that day. I'm try to make the chart only show the names and number of salesperson that are not = to null. This is what the chart has for values right now "=' Nest Average'!$C$6:$C$33". How can I make it so that it only shows those cells if not = to null.

View 2 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

Multiple Series Chart/Graph

May 15, 2008

I have a scatter graph that has over 100 curves that im need on one graph that at the moment i putting each x and y and name in by hand in series. I have been doing it for hours and have looked round the site to see if anything similar answer on ozgrid would help but im baffled

i was just wondering if there is an easier way of doing this

i havent really used macros but iv been reading up on it can i used it to do this?

I have added the table and graph and this is how i would like all the columns to look like
its the table called graph that makes the curves that i would like to be able to add in quickly
the rest im not too fussed about.

View 9 Replies View Related

Create Stacked Bar Chart/Graph

May 29, 2008

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

Combined Bar And Line Graph/Chart

Jul 1, 2008

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.

Computers Data Usage
--------------------------
Computer01 10 50.00%
Computer02 691 68.89%
Computer03 107 81.03%
Computer04 190 81.25%
Computer05 2099 82.89%
Computer06 1247 50.88%
Computer07 2786 10.00%
Computer08 69 22.00%
Computer09 300 18.00%
Computer10 1829 87.07%
Computer11 746 27.43%
Computer12 437 91.33%
Computer13 301 62.50%
Computer14 24 40.00%
Computer15 93 83.33%
Computer16 192 92.45%

View 5 Replies View Related

Graph / Chart Represent Whether Or Not Cell Has Been Filled

May 14, 2014

I am making a spreadsheet that will be used to track employee time usage. I would like to be able to create a graph of the time throughout the day that shows only whether or not the employee has entered an activity during each particular time slot.

EX: The graph shows the time from 8-10am in 30 minute increments. The employee has entered activities for the time slots from 8-9 and 9:30-10. When the graph is created, I would like to see times 8-9 and 9:30-10 filled (or, charted, or, however I should phrase it) and time 9-9:30 left blank (to represent that no work was done).

View 3 Replies View Related

Countif Statement With NA Results For Chart / Bar Graph?

Mar 14, 2014

I have a countif statement based on certain criteria in a table which is reading off of a drop down list on a separate sheet.

Apple (a1) =COUNTIF(Table2[Fruits],+'Drop Downs'!A1) ...and the results are 3
Pear (a2) = =COUNTIF(Table2[Fruits],+'Drop Downs'!A2) ..and the results 0
Banana (a3) = =COUNTIF(Table2[Fruits],+'Drop Downs'!A3) ...and the results are 1

I have also set up a bar graph (this may change to a pie chart at some point) which is feeding from this. My question is, if I do not want to any results with 0 value to show up on my chart (both on the X&Y axis), how do i amend the formula to do this? I read in a couple of places about the NA() function or about just hiding the rows, but if this chart is updated "live"on a weekly or monthly basis, I would like to chart to move with the data simultaneously...so the numbers will change, sometimes they will be 0, others they may not.

View 7 Replies View Related

Chart Or Graph Data Based On Hours

Jan 5, 2010

I would like to chart (pie or graph) sales based on the hour they occured.

In excel, I have column A - the time stamp, and column B, the sale. Note that each sale has its own unique time stamp.

View 9 Replies View Related

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 View Related

Auto-Extending Graph/Chart Range

Aug 21, 2008

I have a Line Graph with 2 lines on it. Is it possible to write a macro to extend the range (Source range) of one of the lines ? I would also like to add a Data Label to the newly added point.

For e.g. If I have Line 1 graph only till 65, I want the macro to extend the range by one row to include 95 and also display a datalabel ......

View 9 Replies View Related

Determine Breaking-Point In Graph/Chart

Jan 27, 2010

finding a function/formula for determining the breaking point (Yvalue) in a graph, that doesn't necessarely equals the maximum value of that curve!

So the curve in the sample is a stress strain curve (tensile test) of a fibre and at the end it breaks and the Y value returns to 0. I would like to determine that Y value before it is 0, so the last Y value before it returns to zero.

I thought of a formula like:
display last y value before it drops with 90%...
but I don't have a clue how to write it in maths...

View 4 Replies View Related

Plot Multiple Series In 1 Graph/Chart

Aug 18, 2006

how can i plot multiple series of values in one graph after checking some check boxes, which i have previously done, randomly?

View 4 Replies View Related

Chart/Graph X Days From Another Workbooks Data

Sep 13, 2006

I have a spreadsheet in the office which is completed and saved in a folder daily. Im looking to add a line chart onto the daily spreadsheet which shows the figures from the last 20odd days so that they can be easily compared.

View 5 Replies View Related

Graph & Chart: Data Source Changes Monthly

Nov 19, 2006

I am trying to write a macro that will automatically change the source data for a graph. This is an existing graph that is on tab GraphYTD and the data for the graph comes from DataYTD. The number of rows of data will change monthly, but I would like to use the same graph template every month. Here is my

Sub SortYTD()
Dim myBottom As Long
myBottom = Sheets("DataYTD"). Range("B65536").End(xlUp).Row
ActiveChart.SetSourceData Source:=Sheets("DataYTD").Range("F2:I" & myBottom)
ActiveChart.Location Where:=xlLocationAsObject, Name:="GraphYTD"

End Sub

I am getting Runtime error 91 - object variable or with block variable not set.

View 3 Replies View Related

Chart A Graph Of Jobs Over A Period Of Time

Jun 17, 2007

I have an Access database, with a table of jobs processed.

One column for Job ID (Unique), Date it was processed, By Who it was processed and Comments ascoiated.

I need to chart a graph of Jobs over a period of time. How many jobs done per date. In excel preferebly, I have programs like Database Plus for excel. And I am familiar with VBA. I can't figure out how to uniquely sort how many jobs for each date. As there are numerous job entries for on the same dates. I think it can be done with an SQL query or sorting it with VBA somehow. Any help will be greatly appreciated. Or can anyone suggest an application designed for charting with Access databases in Excel?

View 6 Replies View Related

ADVERTISEMENT