Chart Printing issue

I am using excel 2000 on windowsXP with SP2.I have pivot charts which are 
getting data from Pivot Tables. One sheet has 6 charts, Which normally get 
printed fine in landscape format.

When I put a group-> Hide detail in one of the columns of first pivot table, 
It starts behaving abruptly.I have tried with multiple files ( I have 7-8 
different files with similar functionality). 

I am using cute pdf for printing PDF. This will print the page in landscape 
format but store the page in portrait format ( The output is file). But if I 
remove the "Hide detail", It starts coming normally i.e. print will be 
landscape as well the storage will be landscape.

Please help!

0
Sandeep (44)
7/23/2009 12:34:21 PM
excel.charting 18370 articles. 0 followers. Follow

0 Replies
598 Views

Similar Articles

[PageSpeed] 32

Reply:

Similar Artilces:

outlook and vpn issue
i am using a vpn connection to get my mail off my companies exchange server from home. my sa set up another email acct on my outlook so i could toggle between my work email and my isp email address. now when i start up my vpn client and then go to outlook i get an error stating something to the effect of "exchange server unreachable". do i need my work email and isp email on seperate profiles? am i not able to receive my isp email while vpn into the network? someone please help! yes, they need to be in different profiles as outlook is directly connected to the work servers when us...

Outlook Calendar Issue
I have an issue with one of my companies calendars. The issue is that one of our ex employees made a daily recurring event that goes on forever with no stop date. His access and accounts have already been deleted. When I as the administrator on the server hosting exchange go to delete this recurrence i get the issue that says: The Item could not be deleted. It was either moved or already deleted, or access was denied. Can any of you help me with this issue, I hate to have to blow away the calendar and remake it. Are these calendars events set as a registry somewhere? I just solved this ...

Print PDF files with margins cut
If I print a pdf file with the source listed below, print out with the trimmed edges. In fact I get a technical drawing with the missing information. The same results if I print from explorer context menu. If I open the pdf file with Acrobat and do printing, the printed sheet is correct. How do I properly print the entire PDF file through code? Thanks Regards i forgot the source that i use: Process proc = new Process(); proc.StartInfo.FileName = "c:\\filo.pdf"; proc.StartInfo.Verb = "Print"; proc.StartInfo.CreateNoWindow = true; proc.StartInf...

Conditional Formatting in Pivot tables/charts
Would anyone happen to know if it is possible to use conditional formatting of information in a pivot table that will result is highlighting of the corresponding bar in a chart? I m trying to set up a pivot table so that if a value is less than a set number it will be highlighted for rapid visual detection. Thanks Gavin B wrote: > Would anyone happen to know if it is possible to use conditional formatting > of information in a pivot table that will result is highlighting of the > corresponding bar in a chart? > I m trying to set up a pivot table so that if a value is less tha...

printing 10-sheet business cards with publisher
how do you print business cards on Avery Ink Jet Business Card #8371 stock (10 cards per page {2" x 3 1/2"}) with Publisher 2000? The dimensions found for "custom printing options" on the microsoft website are only for 8 count paper. Please send response to Chrispisms@buckeye.express.com Here's how I do it using Publisher 2000 Create a card Then; File Print "Page options" button Select "Print multiple copies per sheet" "Custom options" button Fill in the Gaps and Margins of your card stock OK OK OK ...

Free/Busy Issue
I have set the free busy on my Exchange Calendar Resources to 36 months. As a delegate on a test resource, i set my own calender to 36 months of free/busy. When I schedule the resource (we do not do auto accept on our resources) and look at free/bsuy, I can see 35 months in the future. In the same request, I try to schedule another resource where the free/busy is only 3 months, it gives slashes in the timeline for the 3 month calendar, then also my 36 moth free/busy test calendar. I have exit outlook, log into the resource to make sure it says 36 months, log back into my outlook pro...

BUG: Excel Date Issue
I think there is a bug in the Excel Date calculations. I am using Office 2003 and here is what I do Under Tools->Options->Calculation, make sure you are *NOT* using 1904 date formats In 3 cells, enter the following numbers 1 32 60 Select the cells and format them as dates. You get: 1/1/1900 Correct 2/1/1900 Correct 2/29/1900 ***WRONG *** ???? 1900 is not a leap year so how can this be? It's a bug that comes from Lotus 123 and to be compatible MS knowingly added this bug to Excel That was of course during the days when Lotus ruled the spreadsheet world <g> R...

Chart names #2
I am producing an Excel sheet with several pages of identical looking charts sourcing different data sets. 6 charts to a page and 4 pages worth of charts. I am using VBA to automatically change the scale of the charts and want to automate it a bit more: The VB code I want to use is similar to: For Sheet_Num = 1 to 4 For Graph_Num = 1 to 6 Set myRange = Worksheets(Sheet_Num).Range(Graph_Num) etc. Next Next However, I currntly need to put a translation table in to convert the Graph_Num into the actual graph name (Chart 1, Chart 14, Chart 16, etc.) I just want to rename the actu...

Unwanted accounts on Income and Expenses Chart
The expenses from my business accounts show up on the "Income and Expenses" chart on my home page, yet I only want that chart to show my personal expenses. I've excluded these accounts from my "budget and spending tracker" but they are still showing on this chart. Anyone know how to remove them? In microsoft.public.money, new2money wrote: >The expenses from my business accounts show up on the "Income and Expenses" >chart on my home page, yet I only want that chart to show my personal >expenses. I've excluded these accounts from my "...

Chart size
Is there a way to make the User defined chart be made a specific size when created? We will be making multiple charts and I wish them all to be a specific size as they are then copied to Word. Thank you Deborah - If you make the chart with the Chart Wizard, you are stuck with the default size and position, which is *approximately* half of the height and width of the active pane, centered within the pane. You can resize charts by dragging their corners, and if you hold down the Alt key, the chart edges stay aligned with cell boundaries, so you could make the charts the same size this ...

Excel corrupts charts. How do I stop this?
After saving my work in an Excel 2007 file (that has multiple charts) and closing it, the chart formatting is corrupted and I have to resize all the fields every time I open up the file. How do I keep the chart from getting resize within the specified size of the chart? ...

In-line charting
Is it possible to put a bar graph in-line in chart data? Hi Michael, > Is it possible to put a bar graph in-line in chart data? It's nice to be succinct in newsgroups, but sometimes it is possible to carry this too far. One possibility can be found at http://www.edferrero.com/ExcelCharts/tabid/102/Default.aspx - look for 'Chart Selector' which may be on the next page. But perhaps you mean sparklines like those shown here http://www.bissantz.com/sparkmaker/index_en.asp Happy New Year Ed Ferrero www.edferrero.com ...

Printing Register
With Quicken, I could print my register from a certain check # or date, to the present check # or date. I've search all the help pages and it does not appear that I can do that with money. Can I? In microsoft.public.money, Judith wrote: >With Quicken, I could print my register from a certain >check # or date, to the present check # or date. I've >search all the help pages and it does not appear that I >can do that with money. Can I? Reports->ReportsGallery->IncomeAndExpenses->AccountTransactions Click Customize and select the Account and whatever else st...

Printing Sales document
This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C9D490.3508AD30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello People, here is another issue. a.. I have created a User and assigned her a role of "Order Processor" = which is canned in GP 10.0=20 b.. For this Role ID, I am assigning a Task ID called "Print Sales = Documents" under Sales and I specifically checked all boxes related to = printing sales documents.=20 c.. I have granted the "access to print the Sales documents&qu...

Problem creatting charts with VBA
In Excel 2007, when I create a new chart using Charts.Add I get a chart that has all the series of a previously created chart. How can I prevent this? I want a clean slate. I know that in the past I could not avoid having at least one series when creating a chart. I simply redefine the attributes of series one. And this seems to be true of 2007 as well. TheWizEd - Jon Peltier's web page, "Quick Excel Chart VBA Examples," might be useful, at http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html Note that he uses ChartObjects.Add instead of Charts.A...

RPC over https connection issues
Hi-We have 2 exchange 2003 (1 FE, 1 BE) servers. I am trying to enable rpc over https. Our certificate is a thawte certificate which has been added to a client computers browser. When I follow the Microsoft instructions to set up the outlook client and then try to open outlook, it trys to authenticate but never suceeds. The login box just keeps popping up. I do not know what the problem could be. We are trying to configure this first one inside the domain, but it never fully makes the connection. Everything else including OWA via SSL works great. Any ideas? -- jgarcia ...

RegisterWindowMessage, HWND_BROADCAST between exe and dll issue
i have the following problem, that i've been looking at and googling about for past 4 days to no avail. i have an exe, let's call it exe1, that is ours, that runs as some user, "Administrator" in this particular case, on a given machine, that does following: UINT uiStringA = RegisterWindowMessage("StringA") and then has ON_REGISTERED_MESSAGE(uiStringA, stringAHandler); then i have a vendor's exe, that runs as a service under "System" user and that loads 1 standard c dll, which in turn loads 2nd dll, let's call it dll2, which is also ours and m...

Compatiability issue with Microsoft Outlook 2002 and MS Office 200
I am planning to purchase MS Office for Home and Students 2007. My current programme is MS Office XP for Students and Teachers, and I assume I cannot use the upgrade MS Office 2007. My question is - Assuming I have to uninstall my current MS Office and thereby losing MS Outlook which was part of this programme, is there any way I can keep MS Outlook rather than spending a small fortune getting the Outlook 2007 edition? I hope this makes sense and someone is able to help. Thanks -- Linwood70 If you just install the 2007 version, it will upgrade all of your prior = versions to 2007. S...

Insert Table in Preformatted Chart
I have a chart that I have developed that I use for reporting. The chart is updated automatically with the necessary information. I would like to insert unrelated data on the chart in the form of a small table with a link to the information in the workbook as an object on top of a corner of the chart. Is there some way for me to do that? Thanks. Joe Joseph Create two charts for the data and resize the small chart and position it inside the other. Select both charts. Select one, Hold ctr and select other. The on the Drawing Toolbar menu select Group. Regards Peter >-----Original ...

Excel Charting across Worksheets
Hi, I am trying to create a simple line chart using the same cell (C3 in this case) on four contiguous worksheets (Sheet1 through Sheet4) as my 4 data points. I have tried generating the chart using the chart wizard and setting Cell C3 on Sheet 1 as my data series. I then tried modifying that first data point (listed in the data series as 'Sheet1'!$C$3) to read 'Sheet1:Sheet4'!$C$3 (sort of like summing the same cell on different worksheets) but this gives me an error. If any one can show me how to do this either by giving me steps to follow while using the chart wiz...

how do I print data in a spreadsheet data base to a mailing lable. #2
I would lik eto take the data from a customer data base in Excell and print each customers information on a mailing lable can this be done? should I use Access? if it can be done please help me. I currently am using Microsoft Office 2000 ...

Barcodes / Label printing question
Does the function "Serialization" in RMS, affect or perform any validation of the Item Lookup Code length, and that Items corresponding or selected barcode? We use 128-A, and use Retail Realms Fashion Bundle to create UPC numbers. In RMS Serialization is Off. RMS manual states barcodes must be 12 digits and no letters, however, it allows more digits, and letters, to be used as an Item Lookup, and doesnt display any error when selecting barcode 128-A and printing. It seems it will print anything, but the actual printed barcode may not really be the complete Item Lookup code, if ...

Charting #6
I have a universe chart - basically a floating-stacked-bar chart that shows a colored sub-bar for each of four quartiles. There is one of these stacks of four bars for each year across the x axis. On each annual set of floating stacked bars, I would also like to superimpose two data points, perhaps one with a tiny diamond and the other with a tiny circle. Is there an automatic way to have the EXCEL chart deal with this? I know I could, year by year, paste a diamond and circle in approximately the right places but this manual method would be very cumbersome and would not work for ...

Longer Chart Title?
Hi everybody. I found a difficult problem when i want to create chart automaticly from VBA. When the title string is longer than 31 characters excel can't create the chart. Is there any way to avoid this problem? ...

Out of Office Issue
ANy ideas why the Out of Office doesn't send out an auto- reply? Office 2000 has been uninstalled and reinstalled with no success. Updates were loaded but still no success. Any help would be appreciated. Please reply to my email as I rarely get by to read the board. Thanks. >-----Original Message----- >ANy ideas why the Out of Office doesn't send out an auto- >reply? Office 2000 has been uninstalled and reinstalled >with no success. Updates were loaded but still no >success. Any help would be appreciated. Please reply to >my email as I rarely get by ...