Excel Graphs
Hi Experts
In my previous question, Previous Question, I was trying to reduce the size of my graphs and program them so it would always get 3 graphs to a portrait page no matter what happened to the changing dataset.
Andy
Copy-of-Survey-Monkey-Trial-V3.xls
In my previous question, Previous Question, I was trying to reduce the size of my graphs and program them so it would always get 3 graphs to a portrait page no matter what happened to the changing dataset.
Andy
Copy-of-Survey-Monkey-Trial-V3.xls
ASKER
Yes, how do I reduce the size of my graphs and program them so it would always get 3 graphs to a portrait page no matter what happened to the changing dataset?
ASKER
This is great gowflow. I have tweaked the font sizes of the text a wee bit within the code just to get the graphs to display slightly better and also added a main title to the graphs sheet, this will always be a manual entry depending upon the data set, although I was wondering if it would be possible to set the font of cell A1 on the Charts sheet, so that when they type in the title they do not have to worry about formatting?
Andy
Andy
ok
how you would like A1 to be ?
Calibri 16 or 18 bold with center across the page ? is that fine ? do you need this to be repeated at every page so the title shows on each page or only page 1 ? one last thing you want page numbering on each page also something like Page 1 of 16 etc ... in bottom right corner or ... ?
can you post the workbook that you modified so I hv an updated version so if I post something it has your modifications in it ?
gowflow
how you would like A1 to be ?
Calibri 16 or 18 bold with center across the page ? is that fine ? do you need this to be repeated at every page so the title shows on each page or only page 1 ? one last thing you want page numbering on each page also something like Page 1 of 16 etc ... in bottom right corner or ... ?
can you post the workbook that you modified so I hv an updated version so if I post something it has your modifications in it ?
gowflow
ASKER
Calibri 14 Bold centred across the page on the first page would be fine. Page numbering would be good also, bottom right '1 of ...'
Cheers
Andy
Survey-Monkey-Trial-V4.xls
Cheers
Andy
Survey-Monkey-Trial-V4.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
A superb piece of work, thanks gowflow, your efforts are very much appreciated.
Cheers
Andy
Cheers
Andy
your welcome glad I could help.
gowflow
gowflow
if you need my help pls post a link to any question in here.
gowflow
gowflow
ASKER
Great thanks gowflow, where are you based?
gmt +2
does it make a difference where ?
gowflow
does it make a difference where ?
gowflow
ASKER
No no i"m always interested that's all no other reason didn't want to offend
no problem no offence
gowflow
gowflow
ASKER
That was a statement.
Do you have a question for this thread?