Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 21 Jan 2013 19:10:20 +0100Display percent value as progress bar, in cell?https://ask.libreoffice.org/en/question/10210/display-percent-value-as-progress-bar-in-cell/Is there a way to take a cell that has a percent value, (e.g. 0 <= x <= 1), and display it as a progress bar? I'd like to track a long list of (several hundred) items, each of which will have a percent-done value, and as they'll be nested, I'd like to have formulas calculate the percent-done value for the parents, based on what I've entered for the "child" rows. But I'd really like a visual display of these values (e.g. a progress bar that's the width of the column).Mon, 21 Jan 2013 18:47:35 +0100https://ask.libreoffice.org/en/question/10210/display-percent-value-as-progress-bar-in-cell/Answer by horst for <p>Is there a way to take a cell that has a percent value, (e.g. 0 <= x <= 1), and display it as a progress bar? I'd like to track a long list of (several hundred) items, each of which will have a percent-done value, and as they'll be nested, I'd like to have formulas calculate the percent-done value for the parents, based on what I've entered for the "child" rows. But I'd really like a visual display of these values (e.g. a progress bar that's the width of the column).</p>
https://ask.libreoffice.org/en/question/10210/display-percent-value-as-progress-bar-in-cell/?answer=10214#post-id-10214Have you looked at Conditional Formating? Have a look at the following Question (http://ask.libreoffice.org/en/question/4660/color-scales-and-data-bars/)Mon, 21 Jan 2013 19:10:20 +0100https://ask.libreoffice.org/en/question/10210/display-percent-value-as-progress-bar-in-cell/?answer=10214#post-id-10214