I have successfully graphed the following:
=Imenik!$A$1:$A$67;Imenik!$C$1:$C$67
where column C is:
=COUNTIF(Pozivi!K:K;A2)
However, I cannot get the following graph:
=Imenik!$A$1:$A$67;Imenik!$D$1:$D$67
where column D is:
=SUMIFS(Pozivi!L:L;Pozivi!K:K;A2)
Also, what's the formula for graphing all data excluding the first row?
These formulas do not make sense with respect to charting. What do the actual SERIES formulas look like? Select the series in your chart, and copy the formula in the formula bar.
Jon Peltier
http://PeltierTech.com/
The 1st and 3rd code citations are graph formulas. The 2nd and 4th code citations are one of the columns which they graph.
The first and third items are NOT graph formulas. Please follow my directions and post the SERIES formulas.
Jon Peltier
http://PeltierTech.com/
Well, the 1st and 3rd string is what is says under "Raspon podataka za grafikon:" - should be something like "Data range for graph:" in English.
Okay, I guess it's too much trouble to find the SERIES formula. It would be something like this based on the chart's source data, but it's always better to know the precise formula:
=SERIES(;Imenik!$A$1:$A$67;Imenik!$C$1:$C$67;1)
To exclude the first row, or rather to use the first row for the series names, the formula would say this instead:
=SERIES(Imenik!$C$1;Imenik!$A$2:$A$67;Imenik!$C$2:$C$67;1)
What are the signs that you "cannot get" the second chart? Do you get an error message, or does the chart just come up empty? Does the range contain actual numerical values? Or does it contain blanks, errors, or text?
What kind of chart is it? Different chart types treat unplottable data differently.
Jon Peltier
http://PeltierTech.com/
Both are cake graphs.
The first graph (the 1st code quotation) is derived from columns A and C. Column A contains phone numbers in international format (e.g. "+38511234567"). Column C (the 2nd code quotation) contains the number of times the phone number was called. None of the formulas in column C return an error, i.e. they are all integers.
The second graph (the 3rd code quotation) is derived from columns A and D. Column D (the 4th code quotation) contains total call duration for that particular phone number and is in the long time format (37:24:56). None of the formulas in column D return an error, i.e. they all contain some time value.
The first graph comes up ok. The second contains just the column D header ("Ukupno trajanje") as the only graph entry.
Again, SERIES formulas might be very helpful. I've requested them three times already, this makes four.
Make a copy of the first chart. Click on the chart, and see what areas are highlighted on the worksheet. Drag the blue outline from column C to column D. Does the chart still not plot column D as expected?
Jon Peltier
http://PeltierTech.com/
nlovic,
I think English may not be your first language, so you may not use the same words to describe things.
You can find the series formula in the formular bar when you click the chart and then click a chart series. If you have a pie chart, then it should look something like the attached screenshot. Click into the formula bar and copy the formula, then paste it here for inspection.
See attached screenshot.
cheers
Last edited by teylyn; 08-08-2011 at 10:06 PM.
Yes, English is not my first language, but that's not the main problem. The main problem is that I have the Office 2010 Croatian Language Pack installed, so most of Office is in Croatian.
Anyway, I have tried to focus on various elements of the pie, but no SERIES formula is displayed in the formula bar whatever I do. Can you explain step by step how you got that SERIES formula in the formula bar, starting with a new chart?
When you have created a chart, select data in the chart (the pie circle or any wedge of the pie), and the formula will appear in the formula bar.
Jon Peltier
http://PeltierTech.com/
Apart from the language, does your screen look different from the screenshot I posted when you select the data series in the pie chart?
Select the chart, click a pie wedge, take a screenshot that shows the chart and the formula bar and then post that for inspection.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks