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
LVL 7
andymacfAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

[ fanpages ]IT Services ConsultantCommented:
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

That was a statement.

Do you have a question for this thread?
0
andymacfAuthor Commented:
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?
0
gowflowCommented:
Is this what your looking for ?
gowflow
Survey-Monkey-Trial-V4.xls
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

andymacfAuthor Commented:
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
0
gowflowCommented:
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
0
andymacfAuthor Commented:
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
0
gowflowCommented:
Is this what you want ?
gowflow
Survey-Monkey-Trial-V4-1.xls
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
andymacfAuthor Commented:
A superb piece of work, thanks gowflow, your efforts are very much appreciated.

Cheers
Andy
0
gowflowCommented:
your welcome glad I could help.
gowflow
0
gowflowCommented:
if you need my help pls post a link to any question in here.
gowflow
0
andymacfAuthor Commented:
Great thanks gowflow, where are you based?
0
gowflowCommented:
gmt +2
does it make a difference where ?
gowflow
0
andymacfAuthor Commented:
No no i"m always  interested that's all no other reason didn't want to offend
0
gowflowCommented:
no problem no offence
gowflow
0
andymacfAuthor Commented:
Hi gowflow

I have asked another question, if you can help with it?

Next problem

Cheers
Andy
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.