# Graph - Hide If 0

Feb 22, 2007Is there a way you have a graph auto-hide if the data its pulling in equals 0?

Is there a way you have a graph auto-hide if the data its pulling in equals 0?

I have a graph showing budgets for each month of the year, I am trying to hide all of the zeros that are showing over the past month. how it do it.

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

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

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

I want to create a macro that checks whether a specified range of columns is hidden, and

a) hide them if they are not hidden, or

b) unhide them if they are hidden,

i.e. toggle the Hide state.

What method can I use to query the hidden state of a selected range of columns and return a boolean value?

I have a macro in which i can enter the rows i want to hide.

If i want to hide "position 32" i have to enter the number 8 of the row. This works fine. But now if i want to hide the "position 32" from Sheet1 it also should hide the rows 4-8 from Sheet2 [Data with 32].

Or if i hide "position 34" in Sheet1 [row 10] it also should hide the rows 14-18 in Sheet2.

Sub Button294_Click()

If Sheet1.Range("A34:A94") = "HIDE" Then

For Each cell In Range("A27:A94")

If UCase(cell.Value) = "HIDE" Then

cell.EntireRow.Hidden = True

End If

End Sub

I am filtering the data displayed in a chart by hiding columns. I would also like to filter the X-Axis labels by hiding columns. If I do this manually I have no problems but when I run the following macro the chart gives a reference error for the X-axis labels.

Sub ShowA2()

Application. ScreenUpdating = False

num = Sheets.Count

Sheets("X-Axis").Activate

Range(Columns(1), Columns(256)).Select

Selection.EntireColumn.Hidden = False

For a = 1 To 5

Sheets(num - a).Activate

If ActiveSheet.Name = "A2 Data" Then

Columns("A:Q").Select

Range("A10").Activate

Selection.EntireColumn.Hidden = False

Sheets("X-Axis").Activate

Columns("A:E").Select......................

If A1 is also found below A1 (A2,A3,etc) then "HIDE" otherwise "DON'T HIDE"

I want to create a formula which finds out if a value exists below it in the same column. I could then use a filter to remove rows contain the word "HIDE" which will leave me with only rows with DON't HIDE. Then Column A will only contain unique values.How would I create a formula like this?

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?

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 RelatedI 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

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

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

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

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 RelatedI 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?

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

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?

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.

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 a graph as showed below.

Actual graph will contain a larger/longer X-axis (40 instead of 6 readings), but no more than 2 rows af data (A and B), of which one has a seqenced number af data (row B).

Row B alo has got singular points of data superimposed over the cylinders.

I have got all the numbers ready, but I don't know whether or not it is even possible to create a graph like this.

The cylinders have values up to 45.000 (accumulated in row B), the points (black dots) go from 2 to 6.

If so, I'm having trouble selecting the correct template out of the excel's standard list of graphs.

I have data refering to acceleration of a motorcycle. it uses a calculated value representing acceleration.. each value only relates to the one before and after it, and has no real world value example:

RPM 3000 = .1169 acceleration 4000 = .121 5000 = .131 6000 = .141

Now i want to compare my acceleration vs my real world speed based on each gear, below if first gear.

RPM 1497 = 15 kph 2994 = 30 kph 4491 = 45 kph 5988 = 60 kph

So the one axis is common but the values are not equal to one another and how to get the graph to show RPM vs speed and acceleration?

I'm working on a stacked bar graph based on the below info...

Min

Mid

Max

N1

$21.00

$30.00

$38.00

[code]....

I'm trying to adjust the starting point so that it does not start at 0.

For example...

N1 - $21.00 - $38.00

N2 - $26.00 - $45.00

N3 - $30.00 - $53.00

is there a way to do this?

I have the following data:

X Axis - Years (2004, 2005 ,...)

Y Axis - Quantity (imported, exported, produaced)

Z- Axiz - Name of the products

I want to make a graph with teh X, y,z axis in excel. When i use the 3D graphs in excel, it is not taking the z vales connected to teh cell.

I'm trying to figure a way to calculate numbers in arrears as a part of a sum/average/stdevp.

What I've done so far is create a named range called "x_values" that dynamically adjusts itself to the dates given. What I'm trying to do is create a range that finds the avg of each "X_VALUE", and the previous X_VALUE before it.

I tried =offset(x_values,0,0,roll_factor,1) to do the offsetting; but it just starts at the very top of my range .....

I have a sheet that has names in column A and a list of subjects in Row 1. Cells B2:BA25 have the scores acheived for each person in each subject. I was thinking of creating a customisable graph where by there would be a dropdown box that could select a persons name and this would populate a bar graph of all that persons scores.

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) ?

I hope you can help me out on a problem I am having. I would like to create a macro that generates a total graph of my sales.

Per product line I have defined a sheet, and I have a defined area per sheet where the sales are recorded. This sheetlayout is the same for every product line and looks like the following:

date name_customer price quantity

1/1/09 Johan 8.00 5

4/1/09 Peter 12.00 9

24/01/09 Carol 29.50 36

In my totals sheet I want to include a line graph, where every line is a product line, on the x-axis the months, and in the y-axis the total per month.

I am using Excel 2007 if that makes a difference.

To complicate things, I use a macro to first empty the sheet and recalculate the totals per product line.

I am getting old and can't remember how to activiate a graph to accept and show new numbers.

Example: In "Charts and Graphs for Microsoft Office 2007" by Bill how does one get the graph (Figure 3.35) to accept data for the coming months and have the data reflected in the Linear Trend Bar (the forecast bar is not in the figure) but I would like to include it?

how to lock a graph in an unprotected worksheet?

View 7 Replies View RelatedI'm working on a interfacing program between delphi-excel to manipulate data (from delphi tables) and create a graph in excel. The program is almost done, but I'm having problems with the background and foreground color of the graphs, which don't change.

View 9 Replies View RelatedI have implemented a function in VBA which calculates certain values, called 'IndexSim.' These values are not required to be outputted into the spreadsheet, however I would like to create a simple line graph plot of these values against 1,2,....etc however many values are chosen to be created. The code is as follows:

'Create storage for FTSE100 and binary payoff simulations.

Redim IndexSim(1 To SampleSz) As Double

Redim Payoff(1 To SampleSz) As Double

'Do the simulations.

For Cnt = 1 To SampleSz

IndexSim(Cnt) = gBmProcess(Kt, r, q, Vol, TMat - TNow)

If IndexSim(Cnt) >= IndexBetValue Then

Payoff(Cnt) = Range("D18").Value

Else

Payoff(Cnt) = Range("D19").Value

End If

Next Cnt

how I can create a line graph for the 'IndexSim' values, which will update everytime the macro button is clicked.

is it posable to get a graph to popup when the mouse is draded over a certen cell? or maybe to get it to popup in the comments bubble. if that is possible. then is it possible to set pramators that if its above 350 it turns red( on a line graph) and if its below its turns black. this was throwen at my about 20 min ago.

View 8 Replies View RelatedI have a spreadsheet and am in the middle of creating a userform to display the results of data over a given period (period selected by user).

In that userform I would like to display a graph (the graph will be created behind the scene once the date range has been selected). Is there any way that the graph can be displayed on the userform? If so, how?

Is there any possible to add a series to a graph table without having the line in the Graph. i just want to show the difference for information and not in the graph?

i have tried some different things (like having the difference in white so it is not visible, formatting the Axis etc)

See attached picture. Excel 2.JPG

How to plot a step graph?

I have attached a drawing by illustrating the graph that I wish to plot.

Attached Image : jpg Capture.JPG

I have a graph that auto updates but sometimes there is only 1 series and sometimes there is 2,3,4, or 5 series. Is there a way to have the graph update accordingly? and only have have the series that are valid be in the key on the graph. Currently the graph keeps all the series in the key even when there isn't any data for it.

Please see attachment. Use sheet 2 for the graph. and use the drop down menu to select catagory. this ia very quick mock up of the concept.

Graphseries.xlsx

ADVERTISEMENT