[Solved] Stacked Bar Heights Error!
[Solved] Stacked Bar Heights Error!
Hello, I have created a stacked bar chart successfully but the totals ( heights of the bars ) are more than the actual totals! What can be done to correct the problem?
Last edited by Hagar Delest on Sat Apr 20, 2019 10:59 pm, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
Apache OpenOffice 4.1.6 WIndows 10
Re: Stacked Bar Heights Error!
Please upload your ODF type sample file here.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Stacked Bar Heights Error!
Here is a screen shot.
For data '18, the actual total is 4,854,034 but the chart shows 5,000,000. For data '38, the actual total is 2,302,007 but the charts shows 2,500,000.
On a personal note, I visited Budapest last summer. What a beautiful Parliament Building I saw!
For data '18, the actual total is 4,854,034 but the chart shows 5,000,000. For data '38, the actual total is 2,302,007 but the charts shows 2,500,000.
On a personal note, I visited Budapest last summer. What a beautiful Parliament Building I saw!
Apache OpenOffice 4.1.6 WIndows 10
Re: Stacked Bar Heights Error!
Sorry. Having trouble uploading the screen shot. File too big, a message says.
Re: Stacked Bar Heights Error!
The file size limit is 128 KiB in this forrum. Use256 color depth .PNG fileformat. Conver, and optimize your screenshots before you upload them here. Use the free IrfanView software for this task.
Othervise we will get not too much information based on screenshot. Please prepare a real, ODF type document (delete or modify the sensitive data), delete the irrelevant parts (to decrease the file size) and then upload it here.
Off:
There was (in the socializm era) a story about our Parliament Building. The building was appeared on a paper box of a "made in Hungary" shoe, as "logo" of Budapest. Someone - maybe in the USA - commented it:
"What a beautiful shoe factory!"
Othervise we will get not too much information based on screenshot. Please prepare a real, ODF type document (delete or modify the sensitive data), delete the irrelevant parts (to decrease the file size) and then upload it here.
Off:
There was (in the socializm era) a story about our Parliament Building. The building was appeared on a paper box of a "made in Hungary" shoe, as "logo" of Budapest. Someone - maybe in the USA - commented it:
"What a beautiful shoe factory!"
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Stacked Bar Heights Error!
So here is the calc file, Tibor.
- Attachments
-
- MyCalc_Sent.ods
- (31.62 KiB) Downloaded 104 times
Apache OpenOffice 4.1.6 WIndows 10
Re: Stacked Bar Heights Error!
The data of the column "K" in your sample document contains constant numbers (but they are not SUM() formulas), and the values in the culumn "K" not equal with the actual SUM() value of the cells in columns "B-G".
Maybe this fact causes the difference.
The data in the Column "K" maybe are previous results, of the SUM() formulas, and they became as constants - somehow (accidentally).
Maybe this fact causes the difference.
The data in the Column "K" maybe are previous results, of the SUM() formulas, and they became as constants - somehow (accidentally).
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Stacked Bar Heights Error!
Column K reflects sum columns B-F, G not included.Zizi64 wrote:The data of the column "K" in your sample document contains constant numbers (but they are not SUM() formulas), and the values in the culumn "K" not equal with the actual SUM() value of the cells in columns "B-G".
Maybe this fact causes the difference.
The data in the Column "K" maybe are previous results, of the SUM() formulas, and they became as constants - somehow (accidentally).
LibreOffice 6.4.5 on Windows 10
Re: Stacked Bar Heights Error!
Thanks, Tibor.
You are correct. I changed the sum() columns and forgot to account for the change in the total column.
You are correct. I changed the sum() columns and forgot to account for the change in the total column.
Apache OpenOffice 4.1.6 WIndows 10