Andrew
asked on
Excel graphing & comments
Further to the solution provided atPrevious solution, would it also be possible to provide the additional comments that are displayed in the final column of the input sheet, titled 'General Overall Comments' on a separate page of the 'Charts' output after the graphs.
I have added a new sheet 'Sheet1' to the attached file, this is the format I would like the information to be displayed in with any blank lines removed and a solid border around each comment, word wrapped in the cell.
Sample-V8.xlsm
I have added a new sheet 'Sheet1' to the attached file, this is the format I would like the information to be displayed in with any blank lines removed and a solid border around each comment, word wrapped in the cell.
Sample-V8.xlsm
Sorry have to jump out will attend if no one else beat me on this one in couple of hours.
Rgds/gowflow
Rgds/gowflow
I read your post quickly you say
on a separate page of the 'Charts' output after the graphs.
You mean you want these comments to come on a new page after the last Graph on the Graph page ? or on a new sheet ?
gowflow
on a separate page of the 'Charts' output after the graphs.
You mean you want these comments to come on a new page after the last Graph on the Graph page ? or on a new sheet ?
gowflow
here it is I just need to step out still need to fix that it display the cell expanded.
gowflow
Sample-V8.xlsm
gowflow
Sample-V8.xlsm
ASKER
Thanks gowflow. Yes, display after the other charts but on a page on it's own i.e. not sharing a page with the graph/graphs.
Not sure what you mean by needing to fix it display the cell expanded.
Would it also be possible to hide values on the graphs that are zero, and show data labels outside. (Some are displaying inside their segment, others are displaying outside)
Thanks again
Andy
Not sure what you mean by needing to fix it display the cell expanded.
Would it also be possible to hide values on the graphs that are zero, and show data labels outside. (Some are displaying inside their segment, others are displaying outside)
Thanks again
Andy
ok 1 at a time
Do you mean that the comments displays correctly like if it is 2 lines or more you get the row to expand accordingly ? coz when I tried it out here all rows had the same normal height.
About the graphs I will look into that.
gowflow
Do you mean that the comments displays correctly like if it is 2 lines or more you get the row to expand accordingly ? coz when I tried it out here all rows had the same normal height.
About the graphs I will look into that.
gowflow
ASKER
Yes, that's correct rows should expand to show each comment if it is greater than one line. Andy
ok here it is for the graph part (0 not showing and labels outside)
As far as the row height I am confused, is it showing expanded or all are same height ?
gowflow
Sample-V8.xlsm
As far as the row height I am confused, is it showing expanded or all are same height ?
gowflow
Sample-V8.xlsm
ASKER
Hi gowflow
The rows are not expanding, every row is the same height and is chopping off the text.
Regards
Andy
The rows are not expanding, every row is the same height and is chopping off the text.
Regards
Andy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
An excellent solution in super quick time.
Thanks very much, gowflow
Andy
Thanks very much, gowflow
Andy
Your welcome Andy, will keep this one open case you may need some help in the future.
by the way, don't know if you are aware or if this of any interest to you, some Experts do offer paid services if you wish and this would be outside the scope of EE. Case you need dedicated help then just consult the profile of who ever you would like to deal with and they would mention further details for this. For sure it is important to note that the 2 avenues should not be mixed like you cannot take advantage of personal communications with an Expert outside EE and use it when you ask questions in here (like all Experts are treated equal when questions are asked and no one should have inside info from other channels than EE) doing so would be against EE policy.
Rgds/gowflow
by the way, don't know if you are aware or if this of any interest to you, some Experts do offer paid services if you wish and this would be outside the scope of EE. Case you need dedicated help then just consult the profile of who ever you would like to deal with and they would mention further details for this. For sure it is important to note that the 2 avenues should not be mixed like you cannot take advantage of personal communications with an Expert outside EE and use it when you ask questions in here (like all Experts are treated equal when questions are asked and no one should have inside info from other channels than EE) doing so would be against EE policy.
Rgds/gowflow
ASKER
Hi gowflow
Happy New Year
Please ignore this comment, I got to the bottom of what was going on.
Andy
Happy New Year
Please ignore this comment, I got to the bottom of what was going on.
Andy
ASKER
Hi gowflow
My boss asked me to create a business account, and I have raised another job to add an additional feature to the spreadsheet. New task
Would be great if you could help?
Thanks
Andy
My boss asked me to create a business account, and I have raised another job to add an additional feature to the spreadsheet. New task
Would be great if you could help?
Thanks
Andy
Thanks!