Graph - Expandable Range
Feb 1, 2010
i have a range (A2:A30) that has values imported into it (sheet1).
in B2:B30, i'm doing a simple calculation based on the perspective values in A.
The number of values imported into A is different each time my model is run.
i'd like to graph A and B columns against each other but i don't want to have to adjust the range on the graph each time the model is run.
ps. i tried graphing A2:A30 vs. B2:B30 but the graph also shows the empty cells in A so that doesn't work.
View 9 Replies
ADVERTISEMENT
Apr 25, 2014
create cells which could be expanded/shrunk, to either show the first sentence or so of the essay, or the full essay. I'd need to be able to expand/collapse each cell individually, not by row or column as the tutorials I've found have shown. I'm pretty sure I've seen this done with a little +/- sign in the corner of the cell but I can't find the option. It would be a bit like on a website that have show more, show less buttons.
View 2 Replies
View Related
Nov 18, 2013
I download a daily inventory file from my supplier.
.
I sell only selected products from that file.
.
I would like to use a list of the product part numbers of the products I sell on sheet 2 (Inventory) and have all the results from sheet 1 (ProductFeed) built into an expandable table on sheet two including all the parts numbers (expandable because I will add or delete part numbers from the list) I have listed and not just one part number but several.
.
Second issue: the download file contains part numbers in column "A" with variables like 418, 418_color, 418_size etc.... I would like all part numbers that begin with the number 418 and the ones that contain the variable added to be listed in the new table so I will get a list of all part number 418 and the variables which include 418 in them.
.
I want to return the results of the whole row(s) of the matched data as well in the new table.
.
I have attached a file of the working data that I have with the data I will use although the ProductFeed will change daily which I intend to copy and paste into the table each day.
View 2 Replies
View Related
Sep 8, 2006
I am trying to create a graph for a range of data that updates monthly (adding an extra month each time). I wanted the graph source data to update automatically each time the data is refreshed so used an OFFSET formula to identify a named range. I then point the graph to the named range as the source data.
When I enter the range as the source data the graph picks it up. However, when I re-enter the source data option on the graph it has converted the named range into a cell written range (ie. replaces "=QUALITY" with "='Front page'!$B$7:$J$10" - which therefore will not update when the range increases.
View 4 Replies
View Related
Apr 28, 2008
I have a table that has formulas that read off a pivot table. When the pivot table is updated, the other non-pivot table is updated. I created a graph off of the non-pivot table data. I want to do a bar chart, but if data is added to the pivot table (and then through formulas added to my non-pivot table) I want the graph to automatically update with the new fields. I can't figure out how to do this
For example, if my table had Grapes, apples and peaches and their quantities in cell A2:b4 if I choose range a2:b5 I don't get any data in my graph at all, if I choose the correct range a2:b4, I get a bar chart with Grapes, Apples and Peaches and thier quantites. If I added Strawberries to the Pivot table, the non-pivot table would update, but the graph is not grabbing row 5, I have to manually change the range to a2:b5.
View 9 Replies
View Related
Oct 16, 2009
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
View 2 Replies
View Related
May 13, 2014
I have a report that has rolling week by week data (as in YTD). The graphs I have are based on a 13 week period. As I add a week (done by VBA import) I want to update graphs to lastest 13 weeks as in last 13 columns of data on data sheet.
View 4 Replies
View Related
Sep 4, 2006
I am trying to automate a graph for data that is not always the same amount but always in the same format. I have attached a spreadsheet that has an example of the data.
Columns B, D, & E are the ones that I am interested in charting in a line with markers type graph, but the rows may be 100 for one set of data and 1000 rows for another set of data. I am trying to get the macro to open a new worksheet and as part of the macro create a userform that will ask for the text information on the top of the worksheet (as this is not always correct when imported).
View 5 Replies
View Related
May 9, 2008
i have a graph that i've linked to let's say cells A1:C150
however, my range could sometimes needs to be shrunken to A1:A100 or A1:A40 etc. (the number of rows that are "active" is determined by cell K27)
i'd like for my graph to automatically adjust depending on the number of rows that are filled within the range above. can this be done with formulas and graph manipulations?
i've put in a formula currently that makes the value of the cells that would return 0 into "" but that doesn't seem to do the trick.
View 9 Replies
View Related
Jul 23, 2008
I need to select data from columns A, B and I for the graph. I have the below code but get an error message. Can anybody help ?
Set cellGR1 = Cells(2, 1)
Set cellGR2 = Cells(K, 2)
Set cellGR3 = Cells(2, 10)
Set cellGR4 = Cells(K, 10)
Charts.Add ....
View 9 Replies
View Related
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
May 28, 2008
I have a vast database where I have linked charts. I send the data from a macro to the database and sometimes there are 1000 inputs and sometimes there are only 20.
How would i set up my charts to only graph the inputs that are present?
View 7 Replies
View Related
Aug 5, 2013
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
View 5 Replies
View Related
Mar 21, 2014
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 Related
Jun 11, 2006
How can i make a graph that will graph against time? lets say i have a bank balance like this:
1/2/2000 $500
1/3/2000 $600
3/12/2000 $400
there may be more than one entry on any one given day, or there may not be an entry for 2 weeks. How can i graph the running balance in a way that it will show the timeline just as a calendar year(or however long i selected) and the points are plotting according to their date, not just equally spaced out.
View 2 Replies
View Related
Nov 19, 2009
I'm trying to write some code to make an existing chart display the correct series of data. However, on the ".SeriesCollection..." lines, it gives me the error "Object does not support this property or method." I'm using a Bar-Line graph, if it makes any difference.
View 5 Replies
View Related
Dec 30, 2008
I want to use a line graph to display an amount over time - that's the easy part. On the other hand, I would like to have to group the lines based on a value.
A short example:
Imagine you own 3 different stores and you're selling oranges. So your table looks like this:
http://img179.imageshack.us/my.php?image=orangeshm4.jpg
Now I'd like to have one graph (3 different graphs won't work as the rows increase -I need to select the whole column as data source):
Date on the x axis,
Oranges sold on the y axis,
and one line per store (e.g. a green one for store A, a red one for B and a blue one of C, doesn't matter).
View 2 Replies
View Related
Nov 11, 2009
I have a X-Y graph with 602 data points. My x scale is a counter from 1 to 602 and the Y is a decreasing set of numbers. When I hover my mouse over the points on the graph (I zoomed the graph) My first 3 points are all labeled as Point "1". At the end of my graph, my last 3 points are labeled 599,601,602, it skips 600.
I am using Excel 2007. Has anybody seen this before?
View 9 Replies
View Related
Jul 17, 2014
I am creating a graph with a wide range of values (0.06 - 300). The smaller values are barely visible on my column graph. I have tried all of the tricks I know. Any way to get the smaller values to show up instead of just hovering towards the bottom of the graph?
View 9 Replies
View Related
Dec 27, 2013
I need to set up a graph (smooth line chart possibly) with an (x axis) that are not regular intervals. I've attached an example.
the amounts would be (y axis) and the corresponding dates (x axis).
That would be great to start with. Then I have one of these sheets for each month, can there be a continuous graph made using each month or does it need to be individual graphs.
Davyccexamp1.xls
View 4 Replies
View Related
Jul 22, 2014
I want to plot a quadrant graph as in the attachment, but I can't find them. how to plot them.
View 2 Replies
View Related
Feb 27, 2007
I need to create a graph using the data in the following format:
Item X Y
A: 10 100
B: 20 200
C: 30 300
D: 40 400
E: 50 500
etc.
I need to annotate points with A,B,C etc in the scatter plot so that the same can be quickly identified in the graph.
View 9 Replies
View Related
Feb 16, 2009
I have three colums of data.
First represet company , second colum represent data1 ( x- axis) and third represet data2 ( y-axis).
I want to plot x-y graph with the company name
Eg.
McDon | 10 | 20
In the above case i want to show a round circle or dot which will be 10 right on x axis and 20 up on y axis and near the dot i want to show McDon as company name.
See that attachement... Graph is coming well.. but i am not able to add the company name to the dots.. or pot of x and y intersection
View 6 Replies
View Related
Jun 16, 2009
I would like to create a graph where the numbers are grouped in such a way as all numbers between 0 and -1 are shown in one column, all numbers between -1.1 and -2 are shown in the next column, all numbers between -2.1 and 3 are shown in another column etc
The numbers are shown below
11/03/09
-2.5
-3.8
-3.9
-4
-4.1
-4.5
-4.6
-4.9
-5.2
-5.4
-5.4
-5.5.......
View 2 Replies
View Related
Jul 12, 2009
I use spectrometer in my reesearch. The datas are in (a, b) format in single cell. Is it possible to seperate a and b seperately? like a in seperate cell and b in seperate cell?
View 4 Replies
View Related
Feb 4, 2010
I want to carry out a survey in Sept, Oct and Nov. I will asking 1000 random people in each survey what is their personal favourite--- iPhone, Nexus or Blackberry. Counts of each phone type is then divided into male and female.
Now we have three variables: gender, phone type and month. Is there any way I can present 3 variables on X, Y & Z axes and the value at their intersection as bubble size (or colour gradient)? Theoretically it's possible but I can't find a way to do it in excel. Or anyone knows any software that can get the job done?
View 10 Replies
View Related
Nov 29, 2012
See attached sample file. Any way to get column graphs next to each item (horizontally), each column being the revenue for that item.
Attached File : Sample.xlsx
View 4 Replies
View Related
Nov 25, 2008
My macro prduces some text ang a graph on the screen and I can print the result.
Ok so far. But when I run this macro in a different screen resolution, the layout of the page is disturbed: the graph is on the wrong place and the dimensions of the graph are different.
Of course I can drag and resize the graph and include this proces also in the macro but I think this is not the right way. My question is: are in VBA commands which can fix the graph to a location on the sheet/screen and adjust the graph to the requested heighth and width?
View 3 Replies
View Related
Aug 31, 2009
I know that to show a tab in VBA you can write worksheet("NameOfTheTab").select
However, it does not work when the tab is just graph.
View 2 Replies
View Related
Sep 28, 2004
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]....
View 6 Replies
View Related
