Displaying The Chart In A Full View ?
Hello, Using Excel 2007 Have created a chart, and it looks just fine. But, in the chart view sometimes it seems to open up, centered, but only using perhaps half of the available screen area. Big, blue, non-chart area on each side. Other times it fills the whole screen. Both cases, it displays everything, just shrunk in the one view. Is there some way to simply click on something to switch from one "view" to the other ? Thanks, Bob
rgsrose1
excel.charting
18370 articles. 
0 followers.
0 Replies
1344 Views
Similar Artilces:
Select Securities in Portfolio View
In the Portfolio View options (Customize Current View), there is a tab to select Security Type. Then there is a list of security types to choose from. For some reason, I only have two options: I can choose "Select All", or I can pick only one security type. There doesn't seem to be a way to do multiple-select. Is that right...it's either all or one? i'm trying to select everything except for cash. ...
EzPaste-xl2ppt Excel add-in, automating the copy/paste of charts and data
Hello, This is to notify about the release of EzPaste (http:// www.EzPaste.net), an Excel add-in intended to completely automate the transfer of charts and data from Excel to PowerPoint. EzPaste identifies automatically all the charts and the tables defined in the active workbook. The user then selects which of them he wants to paste to PowerPoint=AE , and EzPaste does all the work, would you have to paste one or one hundred tables/charts at once Even if you have to paste the selected range or chart, EzPaste does it with the click of a button Sorry if this message is a bit advertising, b...
Changing to Combination-chart from existing chart
I have made a Line-chart containing 8 different series. I now want to change 2 of the series to Bars, but in the same chart. How do I proceed to pick the wanted series and transform them to bars? Regards Jan Hi Jan, Right click a line series that you wish to change. From the popup menu select Chart type and pick bar. Cheers Andy Jan wrote: > I have made a Line-chart containing 8 different series. I > now want to change 2 of the series to Bars, but in the > same chart. > > How do I proceed to pick the wanted series and transform > them to bars? > > Reg...
Can see form in design view but not in open or layout view
I have set up the tables, relationships and forms. When I first created the form I was able to view when clicking open. I made a couple of changes and now when I click on open a box pops up to enter perimeter value. Also, I can no longer see the form in opne or layout but if I click for design view, I can see my form and all the tabs. There is either something missing or somthing is named incorrectly. Had a similar problem recently where a new version was installed in the front end, but the table in the back end had not been updated properly (a new field) and the new version of the...
upon deleting emails view is not refreshed
We have a sporadic issue that seems to effect the majority of our users (all using Outlook 2007 sp2, but mixed between Exch 2003 and Exch 2007 mailbox servers). When they go to delete items from their inbox, Outlook will occassionally stop refreshing the view. For example when they highlight a message and select "delete" (regardless of hitting the "del" key, right-clicking and selecting Delete or pressing the "x" button) the message remains highlighted until they change folders and return back to the inbox (then the message or messages in question wil...
Static Chart Data Range
Excel-2007, simple line chart: I have a chart that displays several columns of data for rows 2:84. Whenever I insert a new row #2, the new data range for the chart is now 3:85. How do I keep a static data range for my chart (2:84) whenever I insert new rows into the workbook? I have tried editing $A$2:$E$84 to A2:E84 and then saving the changes ... but it is an excercise in futility, it always reverts back to $A$2:$E$84. I would recommend creating a blank row 2, and hiding it. Then, when you insert a new row, you'll be inserting within the boundaries, instead of moving ...
Need help grouping charts
I have identical charts which occur on multiple sheets. Is there any wa to group them for editing? When I group the sheets themselves, it seems to deactivate the charts I tried doing it with a macro as an alternative and then flipping th sheets one by one and keying the macro, but I get a message box with: "Run-time error 1004", "Unable to get the ChartObjects property of th worksheet class". Does anyone have any ideas -- Izz ----------------------------------------------------------------------- Izzy's Profile: http://www.excelforum.com/member.php?action=getin...
Chart to show Portfolio Value over time?
I'm using Money 2003. I would like to be able to see the $ value I have in my portfolio over time. So that I can weep. Money does have a chart view that allows you to see the PRICE history for a given stock over time - but not the dollar value of your investment in the stock over time. In fact, I can't seem to find a view at all that shows you the net value of your portfolio/individual stocks changing over time. The best I've been able to do is to use the "Net Worth" report and unselect all the other accounts. This has insufficient granularity (months instea...
Outlook 2003 viewing problem
We are using Outlook 2003 from the Small Business Edition 2003 software, we have wireless router for our LAN and the modem connected to the router. We have 7 PCs in the Office. The problem is only on one computer, the user is receiving emails from people outside OK, but emails sent internally is another matter. Internal emails although they seem to be being received because the sound alert for new messages happens, but then the message doesn't display in any of the mail boxes. Also sending email from that PC to another internal PC on the LAN is not working. I have checked the ru...
Dialog displayed
Hi I'm creating a dialog and calling it with domodal(). Is there a message handler or something insode my dialogclass that is called after the dialog is displayed? Thanks Urban Yes & No. Take a look at the OnInitDialog() message handler. OnInitDialog() gets called before the dialog is displayed. However you can post a user-defined message to yourself from the OnInitDialog() handler, and handle things that you want to do after the dialog is displayed. -- Cheers Check Abdoul [ VC++ MVP ] ----------------------------------- "Urban Stadler" <mail@ustadler....
how do I display email addresses memorized by autocomplete?
I have many email addresses that autocomplete has memorized, but that have not been entered into my contacts, that I would like to access. Any ideas? This is a great tool for it: http://www.nirsoft.net/utils/outlook_nk2_autocomplete.html -- Ricardo Silva Add-ins for Microsoft(c) Outlook(c) http://www.rsoutlook.com/us/products.html "alyankee" <alyankee@discussions.microsoft.com> wrote in message news:09CC2496-662A-4919-904C-EF6D93A51033@microsoft.com... >I have many email addresses that autocomplete has memorized, but that have > not been entered i...
Data labels for Excel 2007 Charts
Hi, I have charts that are based on dynamically populated data. I need the data labels for all of these charts to appear with 0 decimal places. The dynamic data populates with 2 decimal places (X.XX). Is there a universal setting I can apply to the worksheet or even the chart itself, so I do not have to go to each data point/data label and set the formatting to 0 decimal places? Thanks, Courtney ...
Total in full
Hi all Is there any way to write down total in full, which may vary according to total? i.e: 1.224 Usd = One thousand two hundred and twenty four usd Tks in advance Antonio See http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords In article <93C3E98F-9142-40D7-8EC6-8B6A57657483@microsoft.com>, "Antonio" <Antonio@discussions.microsoft.com> wrote: > Hi all > > Is there any way to write down total in full, which may vary according to > total? > i.e: 1.224 Usd = One thousand two hundred and twenty four usd > > Tks in advance >...
change exist chart to be dynamic
Hi all How can I change an existing chart to be dynamic? In series I saw a name in y axis only but no name of x axis. How can I create a series for x axis? Thanks in advance Daniel You need to understand how dynamic charts work. There are tutorials and links to more on this page: http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Daniel" <Daniel@discussions.microsoft.com> wrote in message news:FF77A61A-58A9-4629-90E1-20742E6...
How do I fix this so I can view my attachments?
I can't view my attachment. I found the following topic in help but it doesn't give me way to fix this so I can view my attachments? I anivirus protection I don't need this feature from outlook. Please advise I see a paperclip next to a message, but when I open it, the attachment is gone. You may have received a message that contains a level 1 e- mail security attachment file type. To prevent the inadvertent spread of viruses, Microsoft Outlook checks the file type of each attachment in a received message against the file types on the e-mail security attachment file type...
Great Plains Invoice History view?
Has anyone built a view in MSCRM that will show Great Plains Invoice history? I would be willing to purchase one. Jake ...
viewing a user's email account
I have been charged with reviewing a user's email activity / mailbox for a possible impropriety. Is there a way to do this from exchange, or better yet what is the best way to accomplish this steathfuly? On Mon, 23 Oct 2006 18:20:02 -0700, Rossel1 <Rossel1@discussions.microsoft.com> wrote: >I have been charged with reviewing a user's email activity / mailbox for a >possible impropriety. Is there a way to do this from exchange, or better yet >what is the best way to accomplish this steathfuly? I really hope that the users' employment contract provides for this ...
ADC not viewing Exchange 5.5 subcontainers....
Does anyone have an idea why the ADC will not let me view and select any subcontainers under the RECIPIENTS container in Exchange 5.5? But if I create a new container, at the "top" level I can then see it via the ADC...but no subcontainers. Is that just the way the ADC is? SRP HI Steve, I believe that is the way the ADC is coded. However, if you select the recipients container as the export container the adc will create the subcontainers in AD if there are objects in the subcontainers. 253826 XADM: How the Active Directory Connector Replicates Subcontainers http://support.m...
IE8 'View Source' opens minimised
Suddenly, after no previous problems, when I open 'Page / View Source' in IE8 it flashes on screen then minimises immediately to the Taskbar. It can be viewed when maximised ok. It can be resized and I have then tried closing whilst holding down Ctrl. It only happens to 'View Source' not any other window. I am perplexed? Hi Bob, It is probably hidden from view behind the IE Window. Just move the IE Window down your screen to see the View Source window behind it. I have noticed the same issue since the last IE security update (last night my time)... It is a...
cannot view all of text in large cell, even though I have it to w.
I have cell format to wrap text and it works fine to a p[oint then no more text is displayed....casn increase the size of the cell, but still only so much will display....rest of the cell show blank. Hi +the limit is 1024 characters. You can extend this with manually inserting linebrekas using aLT+ENTER -- Regards Frank Kabel Frankfurt, Germany sydme wrote: > I have cell format to wrap text and it works fine to a p[oint then no > more text is displayed....casn increase the size of the cell, but > still only so much will display....rest of the cell show blank. ...
Cannot view itme in Public Folder between 2 different exchange 2003
I have 2 Exchange 2003 on WIN2k server. Exchange 2003 (A) has 300 mailboxes and store the public folder. Exchange 2003 (B) has 100 mailboxes. User at Exchange 2003 (B) found that they can view the public folder but no items in it. User at Exchange 2003 (A) do not have this problem. Is the public folder must replicate to other server? Is any suggestion to view the item if no replication on public folder ?? Thanks Dennis JoJo These 2 servers in the same routing group. Exchange 2003 (A) is the Master Exchange 2003 (B) is the Member "omer maydan" <omermaydan@yahoo.com> wr...
Interactive Chart Examples
I once was given an Excel file (protected of course - D'Oh!!!) where the person had charts that were interactive. There were various series and you scrolled thru a scroll bar to select the series you wanted. It would change the chart as you scrolled Can anybody point to samples that folks have done to do this. Previous posts have given a few links but I was hoping that someone has an example That I could use so I do not have to develop one from scratch. Thanks. Homer J. Simpson Hi, Have a look at these examples, Series and data http://peltiertech.com/Excel/Charts/Dynamics.h...
Is it possible to add a "View" button under the purchase order section?
Would be nice to have the abilty to allow someone to be able to view the purchase order as opposed to the given "new, delete, edit, or receive" buttons. This way someone who needed the information and did not have the appropriate security would not be able to delete or change the PO. I tried to CTL S the new, delete, edit and receive buttons, but that basically locks them out completely. Is this something that may be possible? You can make excel pivot table so any employee can view that worksheet from their terminal. This way you can define the fields you want to show as well ...
Outlook/Access 2003
I've been doing a lot of research and purchased (but haven't completely read) Sue Mosher's book. However, before I spend much more time I'd like to find out if my idea is even feasible. The basic idea is to create an appointment system for multiple therapists that can be used by a receptionist and other staff. Using Outlook and Exchange is very nice but the appointment data needs to end up in an Access table immediately. We can purchase SBS 2003 with Exchange 2003 or we can buy a third party tool for calendar sharing whichever would be the easiest to use. I currently...
Default Case View
Could someone tell me how I can setup default views for cases for different users? I know how to change the default view for all users, however I want to make the view different for different users or groups (eg developers, support, etc...) can someone tell me how this can be done in CRM 3.0 please? Thanks, K2 What you are looking for is making the view private so that only certain users can see it. This is done by opening the view in customization and selecting sharing from the actions menu. By adding one or more teams, you'll make the view private to those selected. In other ...
In the Portfolio View options (Customize Current View), there is a tab to select Security Type. Then there is a list of security types to choose from. For some reason, I only have two options: I can choose "Select All", or I can pick only one security type. There doesn't seem to be a way to do multiple-select. Is that right...it's either all or one? i'm trying to select everything except for cash. ...
EzPaste-xl2ppt Excel add-in, automating the copy/paste of charts and data
Hello, This is to notify about the release of EzPaste (http:// www.EzPaste.net), an Excel add-in intended to completely automate the transfer of charts and data from Excel to PowerPoint. EzPaste identifies automatically all the charts and the tables defined in the active workbook. The user then selects which of them he wants to paste to PowerPoint=AE , and EzPaste does all the work, would you have to paste one or one hundred tables/charts at once Even if you have to paste the selected range or chart, EzPaste does it with the click of a button Sorry if this message is a bit advertising, b...
Changing to Combination-chart from existing chart
I have made a Line-chart containing 8 different series. I now want to change 2 of the series to Bars, but in the same chart. How do I proceed to pick the wanted series and transform them to bars? Regards Jan Hi Jan, Right click a line series that you wish to change. From the popup menu select Chart type and pick bar. Cheers Andy Jan wrote: > I have made a Line-chart containing 8 different series. I > now want to change 2 of the series to Bars, but in the > same chart. > > How do I proceed to pick the wanted series and transform > them to bars? > > Reg...
Can see form in design view but not in open or layout view
I have set up the tables, relationships and forms. When I first created the form I was able to view when clicking open. I made a couple of changes and now when I click on open a box pops up to enter perimeter value. Also, I can no longer see the form in opne or layout but if I click for design view, I can see my form and all the tabs. There is either something missing or somthing is named incorrectly. Had a similar problem recently where a new version was installed in the front end, but the table in the back end had not been updated properly (a new field) and the new version of the...
upon deleting emails view is not refreshed
We have a sporadic issue that seems to effect the majority of our users (all using Outlook 2007 sp2, but mixed between Exch 2003 and Exch 2007 mailbox servers). When they go to delete items from their inbox, Outlook will occassionally stop refreshing the view. For example when they highlight a message and select "delete" (regardless of hitting the "del" key, right-clicking and selecting Delete or pressing the "x" button) the message remains highlighted until they change folders and return back to the inbox (then the message or messages in question wil...
Static Chart Data Range
Excel-2007, simple line chart: I have a chart that displays several columns of data for rows 2:84. Whenever I insert a new row #2, the new data range for the chart is now 3:85. How do I keep a static data range for my chart (2:84) whenever I insert new rows into the workbook? I have tried editing $A$2:$E$84 to A2:E84 and then saving the changes ... but it is an excercise in futility, it always reverts back to $A$2:$E$84. I would recommend creating a blank row 2, and hiding it. Then, when you insert a new row, you'll be inserting within the boundaries, instead of moving ...
Need help grouping charts
I have identical charts which occur on multiple sheets. Is there any wa to group them for editing? When I group the sheets themselves, it seems to deactivate the charts I tried doing it with a macro as an alternative and then flipping th sheets one by one and keying the macro, but I get a message box with: "Run-time error 1004", "Unable to get the ChartObjects property of th worksheet class". Does anyone have any ideas -- Izz ----------------------------------------------------------------------- Izzy's Profile: http://www.excelforum.com/member.php?action=getin...
Chart to show Portfolio Value over time?
I'm using Money 2003. I would like to be able to see the $ value I have in my portfolio over time. So that I can weep. Money does have a chart view that allows you to see the PRICE history for a given stock over time - but not the dollar value of your investment in the stock over time. In fact, I can't seem to find a view at all that shows you the net value of your portfolio/individual stocks changing over time. The best I've been able to do is to use the "Net Worth" report and unselect all the other accounts. This has insufficient granularity (months instea...
Outlook 2003 viewing problem
We are using Outlook 2003 from the Small Business Edition 2003 software, we have wireless router for our LAN and the modem connected to the router. We have 7 PCs in the Office. The problem is only on one computer, the user is receiving emails from people outside OK, but emails sent internally is another matter. Internal emails although they seem to be being received because the sound alert for new messages happens, but then the message doesn't display in any of the mail boxes. Also sending email from that PC to another internal PC on the LAN is not working. I have checked the ru...
Dialog displayed
Hi I'm creating a dialog and calling it with domodal(). Is there a message handler or something insode my dialogclass that is called after the dialog is displayed? Thanks Urban Yes & No. Take a look at the OnInitDialog() message handler. OnInitDialog() gets called before the dialog is displayed. However you can post a user-defined message to yourself from the OnInitDialog() handler, and handle things that you want to do after the dialog is displayed. -- Cheers Check Abdoul [ VC++ MVP ] ----------------------------------- "Urban Stadler" <mail@ustadler....
how do I display email addresses memorized by autocomplete?
I have many email addresses that autocomplete has memorized, but that have not been entered into my contacts, that I would like to access. Any ideas? This is a great tool for it: http://www.nirsoft.net/utils/outlook_nk2_autocomplete.html -- Ricardo Silva Add-ins for Microsoft(c) Outlook(c) http://www.rsoutlook.com/us/products.html "alyankee" <alyankee@discussions.microsoft.com> wrote in message news:09CC2496-662A-4919-904C-EF6D93A51033@microsoft.com... >I have many email addresses that autocomplete has memorized, but that have > not been entered i...
Data labels for Excel 2007 Charts
Hi, I have charts that are based on dynamically populated data. I need the data labels for all of these charts to appear with 0 decimal places. The dynamic data populates with 2 decimal places (X.XX). Is there a universal setting I can apply to the worksheet or even the chart itself, so I do not have to go to each data point/data label and set the formatting to 0 decimal places? Thanks, Courtney ...
Total in full
Hi all Is there any way to write down total in full, which may vary according to total? i.e: 1.224 Usd = One thousand two hundred and twenty four usd Tks in advance Antonio See http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords In article <93C3E98F-9142-40D7-8EC6-8B6A57657483@microsoft.com>, "Antonio" <Antonio@discussions.microsoft.com> wrote: > Hi all > > Is there any way to write down total in full, which may vary according to > total? > i.e: 1.224 Usd = One thousand two hundred and twenty four usd > > Tks in advance >...
change exist chart to be dynamic
Hi all How can I change an existing chart to be dynamic? In series I saw a name in y axis only but no name of x axis. How can I create a series for x axis? Thanks in advance Daniel You need to understand how dynamic charts work. There are tutorials and links to more on this page: http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Daniel" <Daniel@discussions.microsoft.com> wrote in message news:FF77A61A-58A9-4629-90E1-20742E6...
How do I fix this so I can view my attachments?
I can't view my attachment. I found the following topic in help but it doesn't give me way to fix this so I can view my attachments? I anivirus protection I don't need this feature from outlook. Please advise I see a paperclip next to a message, but when I open it, the attachment is gone. You may have received a message that contains a level 1 e- mail security attachment file type. To prevent the inadvertent spread of viruses, Microsoft Outlook checks the file type of each attachment in a received message against the file types on the e-mail security attachment file type...
Great Plains Invoice History view?
Has anyone built a view in MSCRM that will show Great Plains Invoice history? I would be willing to purchase one. Jake ...
viewing a user's email account
I have been charged with reviewing a user's email activity / mailbox for a possible impropriety. Is there a way to do this from exchange, or better yet what is the best way to accomplish this steathfuly? On Mon, 23 Oct 2006 18:20:02 -0700, Rossel1 <Rossel1@discussions.microsoft.com> wrote: >I have been charged with reviewing a user's email activity / mailbox for a >possible impropriety. Is there a way to do this from exchange, or better yet >what is the best way to accomplish this steathfuly? I really hope that the users' employment contract provides for this ...
ADC not viewing Exchange 5.5 subcontainers....
Does anyone have an idea why the ADC will not let me view and select any subcontainers under the RECIPIENTS container in Exchange 5.5? But if I create a new container, at the "top" level I can then see it via the ADC...but no subcontainers. Is that just the way the ADC is? SRP HI Steve, I believe that is the way the ADC is coded. However, if you select the recipients container as the export container the adc will create the subcontainers in AD if there are objects in the subcontainers. 253826 XADM: How the Active Directory Connector Replicates Subcontainers http://support.m...
IE8 'View Source' opens minimised
Suddenly, after no previous problems, when I open 'Page / View Source' in IE8 it flashes on screen then minimises immediately to the Taskbar. It can be viewed when maximised ok. It can be resized and I have then tried closing whilst holding down Ctrl. It only happens to 'View Source' not any other window. I am perplexed? Hi Bob, It is probably hidden from view behind the IE Window. Just move the IE Window down your screen to see the View Source window behind it. I have noticed the same issue since the last IE security update (last night my time)... It is a...
cannot view all of text in large cell, even though I have it to w.
I have cell format to wrap text and it works fine to a p[oint then no more text is displayed....casn increase the size of the cell, but still only so much will display....rest of the cell show blank. Hi +the limit is 1024 characters. You can extend this with manually inserting linebrekas using aLT+ENTER -- Regards Frank Kabel Frankfurt, Germany sydme wrote: > I have cell format to wrap text and it works fine to a p[oint then no > more text is displayed....casn increase the size of the cell, but > still only so much will display....rest of the cell show blank. ...
Cannot view itme in Public Folder between 2 different exchange 2003
I have 2 Exchange 2003 on WIN2k server. Exchange 2003 (A) has 300 mailboxes and store the public folder. Exchange 2003 (B) has 100 mailboxes. User at Exchange 2003 (B) found that they can view the public folder but no items in it. User at Exchange 2003 (A) do not have this problem. Is the public folder must replicate to other server? Is any suggestion to view the item if no replication on public folder ?? Thanks Dennis JoJo These 2 servers in the same routing group. Exchange 2003 (A) is the Master Exchange 2003 (B) is the Member "omer maydan" <omermaydan@yahoo.com> wr...
Interactive Chart Examples
I once was given an Excel file (protected of course - D'Oh!!!) where the person had charts that were interactive. There were various series and you scrolled thru a scroll bar to select the series you wanted. It would change the chart as you scrolled Can anybody point to samples that folks have done to do this. Previous posts have given a few links but I was hoping that someone has an example That I could use so I do not have to develop one from scratch. Thanks. Homer J. Simpson Hi, Have a look at these examples, Series and data http://peltiertech.com/Excel/Charts/Dynamics.h...
Is it possible to add a "View" button under the purchase order section?
Would be nice to have the abilty to allow someone to be able to view the purchase order as opposed to the given "new, delete, edit, or receive" buttons. This way someone who needed the information and did not have the appropriate security would not be able to delete or change the PO. I tried to CTL S the new, delete, edit and receive buttons, but that basically locks them out completely. Is this something that may be possible? You can make excel pivot table so any employee can view that worksheet from their terminal. This way you can define the fields you want to show as well ...
Outlook/Access 2003
I've been doing a lot of research and purchased (but haven't completely read) Sue Mosher's book. However, before I spend much more time I'd like to find out if my idea is even feasible. The basic idea is to create an appointment system for multiple therapists that can be used by a receptionist and other staff. Using Outlook and Exchange is very nice but the appointment data needs to end up in an Access table immediately. We can purchase SBS 2003 with Exchange 2003 or we can buy a third party tool for calendar sharing whichever would be the easiest to use. I currently...
Default Case View
Could someone tell me how I can setup default views for cases for different users? I know how to change the default view for all users, however I want to make the view different for different users or groups (eg developers, support, etc...) can someone tell me how this can be done in CRM 3.0 please? Thanks, K2 What you are looking for is making the view private so that only certain users can see it. This is done by opening the view in customization and selecting sharing from the actions menu. By adding one or more teams, you'll make the view private to those selected. In other ...