Dashboard Reporting - plot area changes on print preview

Hi,

I recently tried to create a 'dashboard' style report by using the
camera tool to take pictures of my graphs on different worksheets, and
presenting them together on the first worksheet.  You can see samples
of this type of report at www.exceluser.com

Everything looks good until I try to print preview, at which point
graphic elements on the chart, and the plot area, totally resize.  This
makes the chart unreadable.  Both the camera picture of the chart (on
sheet 1) and the original chart (on sheet 3) are affected.

Does anybody know why this happens, or how to prevent it happening?

Thanks!

0
3/28/2006 10:52:07 PM
excel.charting 18370 articles. 0 followers. Follow

3 Replies
539 Views

Similar Articles

[PageSpeed] 2

ANT:

I use the camera tool to copy sections of my data tables, I don't use it to 
copy charts.

For charts, I create them in cells, very similar to the way Charlie Kyd 
recommends.

I have examples of assigning charts  to cells in this link: 
http://processtrends.com/pg_charts_chart_in_cell.htm

My approach is to create a dashboard sheet. I then set up panels by 
adjusting row and columns sizes, adding spacer rows and columns, then adding 
charts and camera objects. I have a working prototype if you'd like to get a 
test copy  e-mail me: koday@processtrends.com


....Kelly



"Ant." <nospam.anthony@design-industry.com.au> wrote in message 
news:1143586327.441620.216030@t31g2000cwb.googlegroups.com...
> Hi,
>
> I recently tried to create a 'dashboard' style report by using the
> camera tool to take pictures of my graphs on different worksheets, and
> presenting them together on the first worksheet.  You can see samples
> of this type of report at www.exceluser.com
>
> Everything looks good until I try to print preview, at which point
> graphic elements on the chart, and the plot area, totally resize.  This
> makes the chart unreadable.  Both the camera picture of the chart (on
> sheet 1) and the original chart (on sheet 3) are affected.
>
> Does anybody know why this happens, or how to prevent it happening?
>
> Thanks!
> 


0
dkod (205)
3/29/2006 12:41:29 AM
Kelly O'Day wrote:

> I have a working prototype if you'd like to get a
> test copy  e-mail me: koday@processtrends.com

Thanks Kelly, I've sent you an email.

0
3/29/2006 10:39:11 PM
I've had the exact same problem, even when using adobe writter as a printer.  
I found a black and white printer in the office that worked but that does not 
help me.  Did you find an answer to your question?

"Ant." wrote:

> Hi,
> 
> I recently tried to create a 'dashboard' style report by using the
> camera tool to take pictures of my graphs on different worksheets, and
> presenting them together on the first worksheet.  You can see samples
> of this type of report at www.exceluser.com
> 
> Everything looks good until I try to print preview, at which point
> graphic elements on the chart, and the plot area, totally resize.  This
> makes the chart unreadable.  Both the camera picture of the chart (on
> sheet 1) and the original chart (on sheet 3) are affected.
> 
> Does anybody know why this happens, or how to prevent it happening?
> 
> Thanks!
> 
> 
0
tal (2)
4/17/2006 9:21:01 PM
Reply:

Similar Artilces:

Outlook 2000 change in behavior
I don't know if anyone else has experience this but since installing critical updates I have noticed that when I double click to open email messages in my inbox the messages do not immediately open. The hour glass appears and it takes longer than before installing the critical updates for the email messages to open. I have run the detect/repair tool, and disk defrag. My operating system is windows 2000. Any advice is appreciated. Jackie Darden ...

Max clinet change to Cache mode per server
Hi, we have 2 Exchange 2003 a-p Cluster on Unisys ES7000 with 9000 mailboxes on each cluster. The Clients work with Outlook XP. We plan a Rollout of Outlook 2003 SP2 with activated Cache Mode. Our Offline Adressbook has abaout 10 MB and one Mailbox a average space of 35 MB. Now my question, how much client can rolled out parallel that the download of the mailbox content has only small impact to the Exchange Server performance ? Has anybody some experiences in this case Thank you Ingo ...

Printing check register #4
Is there a way to print the check register every month. Example print check register from 12/1/07 to 12/30/07. I dont want to print the whole register mine goes back to 1998. I want a hard copy like a checkbook every month. Rick Under reports, try Account Transactions. You can set dates, which account, and which columns you want to see. "Rick" <rick_falls@hotmail.com> wrote in message news:uh0%235lvpHHA.3644@TK2MSFTNGP02.phx.gbl... > Is there a way to print the check register every month. > Example print check reg...

CRM 3.0 Reports:Error when trying to open reports on client m/c
I am unable to access CRM Reports from any other machine except the CRM Server (Physical) box. I logged in as different users on the CRM server and was able to open and see all of the reports based on roles. But I am not able to view reports from any of the client machines. I am accessing Reports through a web-client. Upon trying to access reports through a client machine, I get the message " An error has occurred. For more information, contact your system administrator". This does not tell me anything I do not see anything unusual in the Web server (CRM Server), or the Da...

How do Print out a uniform spreadsheet i.e. all the same size A3
...

Publisher
Have set up a small report 10 pages in total but when printing page 9 I get additional blank pages printing and then my page 10 how do I stop this from happening? Open the Design Checker, see if it tells you anything. Is the page visible in print preview? What version Publisher? Is the publication setup as a booklet? Publisher works in groups of 4 when printing a booklet. With a ten page booklet setup, Publisher will print a blank page. -- Mary Sauer http://msauer.mvps.org/ "charliegirl" <charliegirl@discussions.microsoft.com> wrote in message news:F995943A-B6A5-4B6B-...

how to change the icon text
To all, What event to I do to handle when my app get iconified? I Need to set the window text for my icon differently than my app title bar text. When I run my app, the window text for the app title bar is "foo", when the user iconifies the app, I want the icon text to be "bar". How do I do that? Thanks for the help, Reza Take a look at CWnd::OnSysCommand. SC_RESTORE and SC_MINIMIZE is what you want to look for in this method. -- Ajay Kalra [MVP - VC++] ajaykalra@yahoo.com "reza razavipour" <rrazavipour@stbernard.com> wrote in message news:uK18XkXH...

Don't plot zero values
I am currently using Excel XP. I have a scatter chart and would only like to plot non zero values. These are not null values. Is there a chart setting I can do to skip plotting zero values or do I need to somehow filter/sort the data first and then plot? TIA George Hey George - If there are true zeros in the data, perhaps the easiest way to exclude them from the chart is to use an autofilter on the data that hides the rows with zeros. Alternatively, you could insert a column to hide the zeros. Say the range with zeros is in B1:B10. Select C1:C10, and enter this formula into C1: =IF...

Button To Print Workbook With Certain Settings
hi, in a workbook i have 52 numbered sheets. they are numbered 1, 2, 3, 4 etc. on the first sheet i have two buttons. i need some coding help with the buttons. basically i want the first button (called even) to print all the even sheets in the workbook. and the second button will print the odd sheets in the workbook. also i want different margin settings for each button. the even button will need a left margin of 0.5 and the odd button will need a right margin of 0.5 - while all the other margins remain 0.2. i am hoping that this is possible. i tried recording the marcos but i am not...

Report Load Error via CRM
I am loading a very basic report that had a complex query but works fine when running it in VS2005. When I attempt to load the report via the CRM 4.0 GUI, I get the following error message: An error has occurred. Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization's Microsoft Dynamics CRM Administrator. Finally, you can contact Microsoft Support." This report does not have any parameters at all, and the most intense thing are embedded select statements which I have done on other reports. I have instal...

Need to populate a Report with several records
In short, I have one report containing 5 records from the same table. The individual records are layed out to support proper printing. I need to populate each record with from the same table. I can not give them all the same pointer to the table or I get 5 copies of the same record. How can I populate those 5 records with 5 records from my table? I think you need to have a group by in your report. Thus you will get 1 group of data for each of the 5 that you are refering to as 5 records. "Bill" wrote: > In short, I have one report containing 5 records from the same t...

distribution group / delivery report exchange 2003
an originator from outside my exchange 2003 organisation is sending an email to a distribution list, but he never receive a delivery report global config, message format for domain * (is ok) [x] delivery report [x] non delivery report "Ronald" <rasch@ltsa.de> wrote: >an originator from outside my exchange 2003 organisation >is sending an email to a distribution list, >but he never receive a delivery report Did he request one? -- Rich Matheisen MCSE+I, Exchange MVP MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm ...

Crystal Report error: information is needed 02-03-04
After reinstalling CRM I get this error when I try to get a report. I know there is information since I'm just asking for the user list. ---------------------------------------- CrystalReportViewer Information is needed before this report can be processed. Information is needed before this report can be processed. ---------------------------------------- Any Ideas? Thanks Also recieved this error, and have logged an issue with MS, no resolution yet. One tip they did provide, remove any underscores ("_") from the server name. This has resolved the issue for a lot ...

Massive Report: Have you ever done this? Help Please
Hi, I am compiling the results of a survey in ACC2003 as a paper appendix. I have about 60 report objects which are about 2 to 4 pages of text each. I have about 60 Pivot Charts and tables as separate form objects. I want to have one report which has the charts and tables and text in it since this would be easy to layout and the page numbering would flow right through. Is this the correct way to do it? I have made a start and the first few pages are fine with charts and tables. However, Access seems to have space restrictions on the height of a report group? When I increase the ...

customizing the task list print options
I'd like to print my "tasks" list but with the complete Note field included. How does one accomplish that? I'm surprised it isn't a standard form provided in Outlook. -- ------------ Michael Bierman ...

Cashiers changing prices: "access pricing" and discounts
Hi: We are a wine shop and give 10% discounts when customers purchase six bottles of wine, and 20% when they purchase 12 bottles. I've got the discounts to automatically kick in when 6 or 12 bottles are scanned into the system using mix and match. However, I've noticed we get an error about "cashier cannot change prices" when the minimum quantity for discount is entered into the system. The reason is b/c the cashier does not have the "access pricing" check box turned on in their detail setup. The problem is we don't want the cashier to have the &quo...

Change Default When Selecting New Message From Form
Whenever I select New -> Choose Form, it defaults to "Organizational Forms Library" (which is empty). How can I make it default to "User Templates in File System"? Thanks. I've been looking for a way to do that for years, but have never found = one. FYI, there is a newsgroup specifically for Outlook forms issues = "down the hall" at microsoft.public.outlook.program_forms or, via web = interface, at = http://www.microsoft.com/office/community/en-us/default.mspx?dg=3Dmicroso= ft.public.outlook.program_forms --=20 Sue Mosher, Outlook MVP Author of Con...

TEXT TO SPEECH CHANGES
Currently my text to speech config reads ONLY LETTERS if the letters are CAPITALs(IE when it come to the word ABLE, it speaks A B L E how can I change the setting to make the system say "able" Thanks Enter this small macro: Sub Macro1() For n = 1 To 100 Cells(n, 1).Speak Next n End Sub And it should "say" whatever text you enter in A1 thru A100 -- Gary's Student "pcor" wrote: > Currently my text to speech config reads ONLY LETTERS if the letters are > CAPITALs(IE when it come to the word ABLE, it speaks A B L E > how can I change...

Reports ???
Hi all, How to generate a report with print preview and print commands? I believe there is no built-in class to generate reports. I would like to generate a report from my application, which reads data from a flat file. Thanks in advance. ...

Simple question
I have an xls sheet that always print 6 copies. When ever I want to print, I have to change it to 1 copy. It's only this one xls sheet. Everything else prints 1 copy like it's suppose to. It's not the printer settings. Like I said, it's just this one xls sheet. Can someone tell me how to make it print 1 copy only and then stay as 1 as the defualt. I have made many changes to the sheet and saved it many times, but it always defaults to 6 copies. Very Strange. Thanks in advance. Phil If maybe as simple as this, as each page can have the page count se individua...

kill formatting brought over from reports
When I export a report from various sources (crystal reports or an Access Database that has an option to send to Excel), the worksheet format buttons stop working, or work erratically depending on something that must be coming over. Also, sometimes I get a sheet sent to me from someone who has done weird formatting, and it overrides my buttons (where the $ sign button produces some custom symbol, for example). I can copy the detail and paste to another worksheet, where the buttons will work, but is there a way to tell Excel to ignore this type of menu change when it receives a spreadsh...

Able to change the fonts and Header in POS
It would nice to configure the font in Point of sale so it would fit into the size quickpad you use. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=e86e0f80-4b12-4bef-9222...

Change color on date field in form for re-certification
My main form has two different date fields on it. One date field needs to be re-certified every 6 months, and the other field needs to be re-certified every 12 months. I would like each of those fields to automatically change color depending on how much time as elapsed since that training. For the 6 month field, months 1-5 should be green, 1 month left should be yellow and anything expired should be red. For the 12 month field, months 1-11 should be green, 1 month left should be yellow, and anything expired should be red. Thank you in advance for your help! messingerjc wrote...

Macro to update information if date changes
using Exel 2000.. I want excel to compare dates on two seperate worksheets and if the date on the first is greater than the second to insert rows and than copy cells on the second to different cells also on the second page. ie..main sheet date is 11-05-08 compared to sheet2 date is 11-04-08...insert cells at a21:d21 and shift cells down (on sheet2) then copy cells b13:h13 to a21:b21 The description seems a bit inconsistent, but here is a shot With Worksheets("Main Sheet") If .Range("A1").Value > Worksheets("Second Sheet").Range("A1&q...

printing business cards #8
I am printing business cards using Publisher 2000. I have no problem setting them up 10 to a page with Avery perforated card stock. The problem is that the design placement on the cards does not print correctly. The top cards on the sheet are perfect but as it gets to the bottom of the page, the design is too high. This is especailly bad whent the design includes a border that ends up not being centered on the card. I have adjusted everything there is to adjust on my printer and am wondering if it is a Publisher software issue or a printer issue. (HP says it is not a problem with the printe...