ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   More Excel Options (https://www.excelbanter.com/excel-discussion-misc-queries/23799-more-excel-options.html)

todd

More Excel Options
 
Thanks for the help on the previous post. Let me take my question one step
further. I want to create a bar graph that displays the fractional value
taken from a table. The caveat is that the denominator of my data set varies
from one data point to the next, which prevents the use of
format/cells/number/custom ?/(common denominator). For example, my data may
look like this: 10/6; 2/1; 8/9; 1/1; 0/0; 0/0; etc. I want to retain the
integrity of the data, and display it atop the bars on the graph. How can I
do this?



All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com