Best way to create a chart w/ xy axis, quartile circles and point plots?
I am looking to create a chart with an x-y axis where each quadrant represents a different category (to receive a rating). There should be four concentric circles representing the quartiles (so the circles/borders would represent 25%, 50%, 75% 100%). I have a chart that calculates provider ratings for each category and in what quartile (what exact %) they fall. I want to put this all together to get an overall picture, but am unsure of the most direct/easiest way to do so. I have attached an image I drew that is basically what I am looking to create in an Excel chart- I'm happy to answer any questions if this is unclear. Any help much appreciated! +-------------------------------------------------------------------+ |Filename: ChartExample1.jpg | |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| +-------------------------------------------------------------------+ -- Jennlax27iga0
Jennlax27iga0.9958829
excel.charting
18370 articles. 
0 followers.
2 Replies
1725 Views
On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: > I am looking to create a chart with an x-y axis where each quadrant > represents a different category (to receive a rating). There should be > four concentric circles representing the quartiles (so the > circles/borders would represent 25%, 50%, 75% 100%). I have a chart that > calculates provider ratings for each category and in what quartile (what > exact %) they fall. I want to put this all together to get an overall > picture, but am unsure of the most direct/easiest way to do so. > > I have attached an image I drew that is basically what I am looking to > create in an Excel chart- I'm happy to answer any questions if this is > unclear. Any help much appreciated! > > > +-------------------------------------------------------------------+ > |Filename: ChartExample1.jpg | > |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| > +-------------------------------------------------------------------+ > > > > -- > Jennlax27iga0 One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it. xt
the.christiesOn Friday, March 2, 2012 8:53:57 AM UTC+13, the.ch...@clear.net.nz wrote: > On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: > > I am looking to create a chart with an x-y axis where each quadrant > > represents a different category (to receive a rating). There should be > > four concentric circles representing the quartiles (so the > > circles/borders would represent 25%, 50%, 75% 100%). I have a chart that > > calculates provider ratings for each category and in what quartile (what > > exact %) they fall. I want to put this all together to get an overall > > picture, but am unsure of the most direct/easiest way to do so. > > > > I have attached an image I drew that is basically what I am looking to > > create in an Excel chart- I'm happy to answer any questions if this is > > unclear. Any help much appreciated! > > > > > > +-------------------------------------------------------------------+ > > |Filename: ChartExample1.jpg | > > |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| > > +-------------------------------------------------------------------+ > > > > > > > > -- > > Jennlax27iga0 > > One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it. > xt On Friday, March 2, 2012 8:53:57 AM UTC+13, the.ch...@clear.net.nz wrote: > On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: > > I am looking to create a chart with an x-y axis where each quadrant > > represents a different category (to receive a rating). There should be > > four concentric circles representing the quartiles (so the > > circles/borders would represent 25%, 50%, 75% 100%). I have a chart that > > calculates provider ratings for each category and in what quartile (what > > exact %) they fall. I want to put this all together to get an overall > > picture, but am unsure of the most direct/easiest way to do so. > > > > I have attached an image I drew that is basically what I am looking to > > create in an Excel chart- I'm happy to answer any questions if this is > > unclear. Any help much appreciated! > > > > > > +-------------------------------------------------------------------+ > > |Filename: ChartExample1.jpg | > > |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| > > +-------------------------------------------------------------------+ > > > > > > > > -- > > Jennlax27iga0 > > One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it. > xt On Friday, March 2, 2012 8:53:57 AM UTC+13, the.ch...@clear.net.nz wrote: > On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: > > I am looking to create a chart with an x-y axis where each quadrant > > represents a different category (to receive a rating). There should be > > four concentric circles representing the quartiles (so the > > circles/borders would represent 25%, 50%, 75% 100%). I have a chart that > > calculates provider ratings for each category and in what quartile (what > > exact %) they fall. I want to put this all together to get an overall > > picture, but am unsure of the most direct/easiest way to do so. > > > > I have attached an image I drew that is basically what I am looking to > > create in an Excel chart- I'm happy to answer any questions if this is > > unclear. Any help much appreciated! > > > > > > +-------------------------------------------------------------------+ > > |Filename: ChartExample1.jpg | > > |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| > > +-------------------------------------------------------------------+ > > > > > > > > -- > > Jennlax27iga0 > > One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it. > xt On Friday, March 2, 2012 8:53:57 AM UTC+13, the.ch...@clear.net.nz wrote: > On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: > > I am looking to create a chart with an x-y axis where each quadrant > > represents a different category (to receive a rating). There should be > > four concentric circles representing the quartiles (so the > > circles/borders would represent 25%, 50%, 75% 100%). I have a chart that > > calculates provider ratings for each category and in what quartile (what > > exact %) they fall. I want to put this all together to get an overall > > picture, but am unsure of the most direct/easiest way to do so. > > > > I have attached an image I drew that is basically what I am looking to > > create in an Excel chart- I'm happy to answer any questions if this is > > unclear. Any help much appreciated! > > > > > > +-------------------------------------------------------------------+ > > |Filename: ChartExample1.jpg | > > |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| > > +-------------------------------------------------------------------+ > > > > > > > > -- > > Jennlax27iga0 > > One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it. > xt On Friday, March 2, 2012 8:53:57 AM UTC+13, the.ch...@clear.net.nz wrote: > On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: > > I am looking to create a chart with an x-y axis where each quadrant > > represents a different category (to receive a rating). There should be > > four concentric circles representing the quartiles (so the > > circles/borders would represent 25%, 50%, 75% 100%). I have a chart that > > calculates provider ratings for each category and in what quartile (what > > exact %) they fall. I want to put this all together to get an overall > > picture, but am unsure of the most direct/easiest way to do so. > > > > I have attached an image I drew that is basically what I am looking to > > create in an Excel chart- I'm happy to answer any questions if this is > > unclear. Any help much appreciated! > > > > > > +-------------------------------------------------------------------+ > > |Filename: ChartExample1.jpg | > > |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| > > +-------------------------------------------------------------------+ > > > > > > > > -- > > Jennlax27iga0 > > One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it. > xt On Friday, March 2, 2012 8:53:57 AM UTC+13, the.ch...@clear.net.nz wrote: > On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: > > I am looking to create a chart with an x-y axis where each quadrant > > represents a different category (to receive a rating). There should be > > four concentric circles representing the quartiles (so the > > circles/borders would represent 25%, 50%, 75% 100%). I have a chart that > > calculates provider ratings for each category and in what quartile (what > > exact %) they fall. I want to put this all together to get an overall > > picture, but am unsure of the most direct/easiest way to do so. > > > > I have attached an image I drew that is basically what I am looking to > > create in an Excel chart- I'm happy to answer any questions if this is > > unclear. Any help much appreciated! > > > > > > +-------------------------------------------------------------------+ > > |Filename: ChartExample1.jpg | > > |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| > > +-------------------------------------------------------------------+ > > > > > > > > -- > > Jennlax27iga0 > > One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it. > xt On Friday, March 2, 2012 8:53:57 AM UTC+13, the.ch...@clear.net.nz wrote: > On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: > > I am looking to create a chart with an x-y axis where each quadrant > > represents a different category (to receive a rating). There should be > > four concentric circles representing the quartiles (so the > > circles/borders would represent 25%, 50%, 75% 100%). I have a chart that > > calculates provider ratings for each category and in what quartile (what > > exact %) they fall. I want to put this all together to get an overall > > picture, but am unsure of the most direct/easiest way to do so. > > > > I have attached an image I drew that is basically what I am looking to > > create in an Excel chart- I'm happy to answer any questions if this is > > unclear. Any help much appreciated! > > > > > > +-------------------------------------------------------------------+ > > |Filename: ChartExample1.jpg | > > |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| > > +-------------------------------------------------------------------+ > > > > > > > > -- > > Jennlax27iga0 > > One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it. > xt On Friday, March 2, 2012 8:53:57 AM UTC+13, the.ch...@clear.net.nz wrote: > On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: > > I am looking to create a chart with an x-y axis where each quadrant > > represents a different category (to receive a rating). There should be > > four concentric circles representing the quartiles (so the > > circles/borders would represent 25%, 50%, 75% 100%). I have a chart that > > calculates provider ratings for each category and in what quartile (what > > exact %) they fall. I want to put this all together to get an overall > > picture, but am unsure of the most direct/easiest way to do so. > > > > I have attached an image I drew that is basically what I am looking to > > create in an Excel chart- I'm happy to answer any questions if this is > > unclear. Any help much appreciated! > > > > > > +-------------------------------------------------------------------+ > > |Filename: ChartExample1.jpg | > > |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| > > +-------------------------------------------------------------------+ > > > > > > > > -- > > Jennlax27iga0 > > One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it. > xt On Friday, March 2, 2012 8:53:57 AM UTC+13, the.ch...@clear.net.nz wrote: > On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: > > I am looking to create a chart with an x-y axis where each quadrant > > represents a different category (to receive a rating). There should be > > four concentric circles representing the quartiles (so the > > circles/borders would represent 25%, 50%, 75% 100%). I have a chart that > > calculates provider ratings for each category and in what quartile (what > > exact %) they fall. I want to put this all together to get an overall > > picture, but am unsure of the most direct/easiest way to do so. > > > > I have attached an image I drew that is basically what I am looking to > > create in an Excel chart- I'm happy to answer any questions if this is > > unclear. Any help much appreciated! > > > > > > +-------------------------------------------------------------------+ > > |Filename: ChartExample1.jpg | > > |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| > > +-------------------------------------------------------------------+ > > > > > > > > -- > > Jennlax27iga0 > > One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it. > xt On Friday, March 2, 2012 8:53:57 AM UTC+13, the.ch...@clear.net.nz wrote: > On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: > > I am looking to create a chart with an x-y axis where each quadrant > > represents a different category (to receive a rating). There should be > > four concentric circles representing the quartiles (so the > > circles/borders would represent 25%, 50%, 75% 100%). I have a chart that > > calculates provider ratings for each category and in what quartile (what > > exact %) they fall. I want to put this all together to get an overall > > picture, but am unsure of the most direct/easiest way to do so. > > > > I have attached an image I drew that is basically what I am looking to > > create in an Excel chart- I'm happy to answer any questions if this is > > unclear. Any help much appreciated! > > > > > > +-------------------------------------------------------------------+ > > |Filename: ChartExample1.jpg | > > |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| > > +-------------------------------------------------------------------+ > > > > > > > > -- > > Jennlax27iga0 > > One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it. > xt On Friday, March 2, 2012 8:53:57 AM UTC+13, the.ch...@clear.net.nz wrote: > On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: > > I am looking to create a chart with an x-y axis where each quadrant > > represents a different category (to receive a rating). There should be > > four concentric circles representing the quartiles (so the > > circles/borders would represent 25%, 50%, 75% 100%). I have a chart that > > calculates provider ratings for each category and in what quartile (what > > exact %) they fall. I want to put this all together to get an overall > > picture, but am unsure of the most direct/easiest way to do so. > > > > I have attached an image I drew that is basically what I am looking to > > create in an Excel chart- I'm happy to answer any questions if this is > > unclear. Any help much appreciated! > > > > > > +-------------------------------------------------------------------+ > > |Filename: ChartExample1.jpg | > > |Download: http://www.excelbanter.com/attachment.php?attachmentid=302| > > +-------------------------------------------------------------------+ > > > > > > > > -- > > Jennlax27iga0 > > One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it. > xt I've put an example at http://www.mediafire.com/?6wmg88htqf9twjz using a polar chart I had hanging around xt
Similar Artilces:
How to select series in chart?
I know I asked this question before, but (sigh) I cannot find the answer now, when I need it of course. How can I select a series in an Excel chart (XY Scatter) using the keyboard, not the mouse? The issue is: I have overlapping series, so it is difficult for me to select a series by moving the mouse cursor to a point in one series and right-clicking it, as I normally do. Someone once mentioned a ctrl and/or shift key combination (I think) that would allow me to select each series explicit in round-robin fashion. That is what I am looking for again. More generally, how could I have found...
double clicking and draging a column in a chart to chg data
in Excel 2003, double clicking on a column in a chart and then dragging the column up or down would change the data in a table upon which the chart depended. How does one do this in excel 2007? Tom Hi, That feature has been removed in 2007, there is no way to do it. If this helps, click the Yes button. -- Thanks, Shane Devenshire "Tom of inns" wrote: > in Excel 2003, double clicking on a column in a chart and then dragging the > column up or down would change the data in a table upon which the chart > depended. > > How does one do this in excel 2007? &g...
Problems with creating a newsletter
I chose the form "Newsletter - email". I have created a 3 page newsletter. Now, I have NO IDEA how to send it out as an email. I do not want to send it as an attachment. I cannot figure out which "save as" format or what I need to do so that i can email this newsletter. Is there a website that goes through how to do this? Am I correct when I say that it has to be html in order for me to send it as email? That is not one of the options. Any help you give me would be greatly appreciated. Thank you, Markis www.adreamforabetterworld.com ...
Linking a Chart with graphics to ppt
Dear group, when I create a chart with scatters, which carry graphics like Excel-Block-Arrows and link this to Powerpoint, the graphics are shown there in a very low quality with large pixels. Any ideas how to improve this? Thanks in advance, Holger. ...
chart MAcro to change on activecell
Here is the macro below.. The only problem is that the columns change every month. so range (columns)keeps widening.... I have sorted it by selecting range upto column N. so it is provided for all 12 months. But now the "Grand total" column which is always the last column also gets included..(.which shouldnt be included in the range for the chart) Is there a way to modify this macro ? Sub updatechart1() Dim ThechartObj As ChartObject Dim Thechart As Chart Dim Userrow As Long Dim CatTitles As Range Dim SrcRange As Range Dim SourceData As Range If Sheets("summary").Ch...
Multiple stacked bar charts
I have a project where i have to chart the compliance of three groups over a number of months. So for each data set there is a Compliance#1 stacked upon NonCompliance#1, then Compliance#2 stacked upon NonCompliance#2 and finally, you guessed it, Compliance#3 stacked upon NonCompliance#3. When i design a chart in excel it wants to place everything on top of each other producing one column of six not the required three columns of two for each week in the display. Can anyone point me i the right direction for this one?? Hi you can achieve this effect by having two layers in your x axis the at...
transparent areas in charts?
How do you create transparent areas in imbedded charts? (for Excel 2003). When I click on "Format Chart area", then "Fill effects", there is a place where you can change the transparency settings, but it is faded out and will not work. Any Ideas? You can make most elements totally transparent. Ignore the transparency button, which is only for decoration. Instead, if you set an element's area to none, the element will be transparent. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech....
printing 2 charts on single page
Using Excel 2k, Win 2k I was trying to print to line charts on a single page to demonstrate the corelation between the two data sets. I would like to print in portait mode with one chart on top of page and one on bottom. Excel only seems to offer putting chart 2 on a separate page or embedding it in chart one. I am not very familiar with excel charting capabilites can anyone suggest a resorce? Thanks ...
VBA to creating autotext entries or quickparts in different catego
I have a VBA application that basically allows people to easily create autotext entiries, move them between machines and use them making comments on assignments. Currently it operates in EXACTLY the same way in Word 2003 and 2007 (using userforms) and I want to keep that as long as possible. You can see the application at http://emarking-assistant.baker-evans.com and either the screen image or the video demos will give you an idea of what I am doing Currently I store all the comments in a long list of autotext entries that is displayed in a field with the value of the entr...
Opening pub files created with older Publisher versions #2
I have just upgraded to Publisher 2003 from 2000 and am having trouble with pub files sent to me for our chuch newsletter which is using Publisher 97 The text is not wrapping around graphics boxes. Can I fix this? I really don't want to go back to Pub 200 Thank Richard this is caused by Publisher 97 not been printer independent. Even if you went back to Publisher 2000, unless you have the identical font versions and printer driver you would have issues with formatting. It sounds like the person sending you the file has a garbage HP inkjet printer. Get them to install the HP5P laser p...
Page setup for 8.5x11 calendar w/picture on tabloid paper?
How can I set up a calendar with 8.5x11 (landscape) pages with pictures for each month to print on tabloid (11x17) paper so it can be saddle stiched? I would like the picture on the top half and calendar on the bottom half. I keep ending up with two of the same pictures on one page and two calendars on the next page. Thanks, Bob I assume you are taking this to a professional printer so why not just set each page up as a landscape 8� x 11 and let your printer do the rest? -- JoAnn Paules MVP Microsoft [Publisher] "Bob at 4799" <Bob at 4799@discussions.microsoft.com>...
Non-VBA way of making custom menus.
Sorry for the new thread but even on Google, the thread isn't showing up. Well, it was SOOO easy, as I knew it would be. The webpage I quoted in my message this morning didn't mention the "New Menu" at all! So, here is the non-VBA way to create a custom menu: - TOOLS > CUSTOMIZE - under the categories available choose NEW MENU and then drag the NEW MENU option under the Commands window up to the menu bar (like D'UH!! <lol> Wish all those hours spent searching yielded webpages that gave this! <g>) - THEN one can go back to the MACROS category a few line...
Creating Text Box in Publisher 2007 Crashes the Application
Hello, we have a clean install of Publisher 2007 under Windows XP SP2, and when we try to create a text box in a document, (both an existing document and a blank document), publisher crashes. Office is fully patched. I ran Office Diagnostics from the help menu and no problems were found and the issue persists. Any thoughts on how to resolve the issue? Thanks, Syd See if selecting a different printer as default helps. How to view error signatures if an Office program experiences a serious error and quits http://support.microsoft.com/kb/289508/en-us -- Mary Sauer MSFT MVP http://of...
Creating a Macro to Delete Commas #2
I have an excel file that the size will varry. I need a macro that will check all the fields for a comma. If there is one I would like to get rid of it. Does anyone have any idea how to do this? I have no idea and I have been assigned this task. Help --- Message posted from http://www.ExcelForum.com/ No macro required. ctrl-H for find/replace. find , replace nothing (leave the replace field blank). You can of course record that within a macro if you wish. Drabbacs >-----Original Message----- >I have an excel file that the size will varry. I need a macro that will >check ...
Create Exchange mailbox from command line
I'm writing a script using dsadd and I was wondering if it's possible to create an exchange mailbox from the command line. Donovan Maybe not exactly what you want but it may help: http://www.joeware.net/win/free/tools/exchmbx.htm -- Neil Hobson Exchange MVP For Exchange news, links, and tips, check: http://www.msexchangeblog.com "Donovan Linton" <DonovanLinton@discussions.microsoft.com> wrote in message news:D9C839EF-883D-4E2E-8BE9-57782582F043@microsoft.com... > I'm writing a script using dsadd and I was wondering if it's possible to > create an ...
creating a backup on 2002 for Money 98
I am helping a friend who has 98. I need to make a backup of info on my 2002 for him to use on 98. Any suggestions as to how to do this? M98 can't read any file written by M02 besides .QIF import. M02 can't write any file readable by M98 except for .QIF export. Sounds like QIF export/import is your only choice. I suspect you will find this doesn't do what you want. "Carlotte" <Carlotta41@discussions.microsoft.com> wrote in message news:015b01c3d2fa$bbf8fd60$a101280a@phx.gbl... > I am helping a friend who has 98. I need to make a > backup of info on...
copy chart from Excel to Powerpoint
I am trying to copy a chart from Excel to Powerpoint, but the button is grayed out and it won't let me copy it. You can convert the chart to a GIF (a picture) with my Excel Objects converter. http://www.geocities.com/excelmarksway "Hoffperson" wrote: > I am trying to copy a chart from Excel to Powerpoint, but the button is > grayed out and it won't let me copy it. ...
Help! charts disappearing, new charts crashing powerpoint
When i open a presentation the charts vanish...i have restarted, they come back. I try to edit a chart, and it crashes powerpoint after a few clicks. What can I do...whole afternoon going crazy! If you are using v 2007 there is a hotfix which is meant to cure some chart crashing problems http://support.microsoft.com/default.aspx?scid=kb;en-us;976479&sd=rss&spid=11264 -- john ATSIGN PPTAlchemy.co.uk Free PPT Hints, Tips and Tutorials http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html "UKExcelgeek" wrote: > When i open a pres...
Start macro creating a mail with contact data and autotext
Hallo, I am working with an user form. The developing of that form started with Outlook XP with a lot of code inside for different buttons. I changed to Outlook 2007 and unfortunately the code of the form was not longer displayed. What I learned about this is that MS does not support to much code in the form (or maybe a bug). They also do not support any longer. I was sending this form to MS support but they told it is do much code inside and they do not know, why the code is not displayed. In Outlook 2003 the code is displayed as in Outlook XP. Because I do not know real...
SQL query / Formula for Reorder Point?
Is it possible to issue an SQL command(s) that would: 1. Set the Restock Level for all items to be equal to the current on-hand quantity for each item. 2. Set the Reorder point for all items to be equal to 1/3 of that items Restock Level. I'm currently doing this manually, or using a formula in excel when items are initially imported into the DB, but there are still several thousand that need to be retro-fitted like this... Thanx in advance! -=RFM=- UPDATE Item SET RestockLevel=(Quantity - QuantityCommitted) UPDATE Item SET ReorderPoint=ROUND(RestockLevel/3,0) - Evan Culver Ne...
RPC Over HTTP on Single Server
I have installed Exchange 2003 SP1 on a single server and installed and configured OWA. In following KB 833401, it says to add reg. entries to the \NTDS service. I don't have Active Directory installed on the computer. How do I ensure a proper configuration (see below), when this option is not avail. since I did not install AD, as suggested, on the Exchange 2003 server. "Configure all your global catalogs to use specific ports for RPC over HTTP for directory services" HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NTDS\Parameters\NSPI interface protocol sequences...
Text box in Embedded chart is cut off
Hi. I am having a problem with an embedded chart that appears differently in word versus how it appeared originally in Excel. Specifically, the top of the chart (in excel) has a text box that divides the chart (it is a vertical bar graph) into subcategories (labels at the bottom are used to specify what each bar signifies; but these are taken from the associated cell range). Originally, the chart was labeled by a single text box, separated by spaces: Lifetime Use 30-Day Use Heavy Use Antisocial Behavior When this chart is linked in word, the text displays like this (tho&...
difference between 2 lines in a scatter chart
I have created a scatter chart with two lines. The x axis is divided up into 10 parts and labeled 10, 20, 30, 40, etc. What I want to do is calculate the distance between the two lines between the x values of 40 and 60. Does anyone know how to to that? Thank you in advance. -- prd02003 ------------------------------------------------------------------------ prd02003's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25762 View this thread: http://www.excelforum.com/showthread.php?threadid=391727 How did you generate the lines? Are they from the data directly...
Chart help Hide Months
I have a data sheet that has historical data, I only want to chart 13 months instead of all the data. Is there a way to do this? hide em -- Don Guillett SalesAid Software dguillett1@austin.rr.com "lmossolle@nc.rr.com" <lmossollencrrcom@discussions.microsoft.com> wrote in message news:EEF19AB1-9092-4B52-868E-574232FC8AC0@microsoft.com... >I have a data sheet that has historical data, I only want to chart 13 >months > instead of all the data. Is there a way to do this? Hi, If your data increase each month have a look at Jon Peltier's example of dynamic na...
XML Mapping: Creating a "non-repeating schema element" in VS2005
Question regarding XML mapping in Excel. XML Mapping in Excel allows you to map "non-repeating schema elements" to an individual cell while "repeating schema elements" automatically get handled as an Excel "list". I want a table(XML/XSD) exported from a VS2005 dataset to be CELL mappable rather than LIST mappable. Is there a way to make Excel interpret the native dataset XML/XSD as non-repeating? Said differently, what makes a schema element "repeating" versus "non-repeating"? Is it a unique XPATH statement? If my underlying table has...
I know I asked this question before, but (sigh) I cannot find the answer now, when I need it of course. How can I select a series in an Excel chart (XY Scatter) using the keyboard, not the mouse? The issue is: I have overlapping series, so it is difficult for me to select a series by moving the mouse cursor to a point in one series and right-clicking it, as I normally do. Someone once mentioned a ctrl and/or shift key combination (I think) that would allow me to select each series explicit in round-robin fashion. That is what I am looking for again. More generally, how could I have found...
double clicking and draging a column in a chart to chg data
in Excel 2003, double clicking on a column in a chart and then dragging the column up or down would change the data in a table upon which the chart depended. How does one do this in excel 2007? Tom Hi, That feature has been removed in 2007, there is no way to do it. If this helps, click the Yes button. -- Thanks, Shane Devenshire "Tom of inns" wrote: > in Excel 2003, double clicking on a column in a chart and then dragging the > column up or down would change the data in a table upon which the chart > depended. > > How does one do this in excel 2007? &g...
Problems with creating a newsletter
I chose the form "Newsletter - email". I have created a 3 page newsletter. Now, I have NO IDEA how to send it out as an email. I do not want to send it as an attachment. I cannot figure out which "save as" format or what I need to do so that i can email this newsletter. Is there a website that goes through how to do this? Am I correct when I say that it has to be html in order for me to send it as email? That is not one of the options. Any help you give me would be greatly appreciated. Thank you, Markis www.adreamforabetterworld.com ...
Linking a Chart with graphics to ppt
Dear group, when I create a chart with scatters, which carry graphics like Excel-Block-Arrows and link this to Powerpoint, the graphics are shown there in a very low quality with large pixels. Any ideas how to improve this? Thanks in advance, Holger. ...
chart MAcro to change on activecell
Here is the macro below.. The only problem is that the columns change every month. so range (columns)keeps widening.... I have sorted it by selecting range upto column N. so it is provided for all 12 months. But now the "Grand total" column which is always the last column also gets included..(.which shouldnt be included in the range for the chart) Is there a way to modify this macro ? Sub updatechart1() Dim ThechartObj As ChartObject Dim Thechart As Chart Dim Userrow As Long Dim CatTitles As Range Dim SrcRange As Range Dim SourceData As Range If Sheets("summary").Ch...
Multiple stacked bar charts
I have a project where i have to chart the compliance of three groups over a number of months. So for each data set there is a Compliance#1 stacked upon NonCompliance#1, then Compliance#2 stacked upon NonCompliance#2 and finally, you guessed it, Compliance#3 stacked upon NonCompliance#3. When i design a chart in excel it wants to place everything on top of each other producing one column of six not the required three columns of two for each week in the display. Can anyone point me i the right direction for this one?? Hi you can achieve this effect by having two layers in your x axis the at...
transparent areas in charts?
How do you create transparent areas in imbedded charts? (for Excel 2003). When I click on "Format Chart area", then "Fill effects", there is a place where you can change the transparency settings, but it is faded out and will not work. Any Ideas? You can make most elements totally transparent. Ignore the transparency button, which is only for decoration. Instead, if you set an element's area to none, the element will be transparent. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech....
printing 2 charts on single page
Using Excel 2k, Win 2k I was trying to print to line charts on a single page to demonstrate the corelation between the two data sets. I would like to print in portait mode with one chart on top of page and one on bottom. Excel only seems to offer putting chart 2 on a separate page or embedding it in chart one. I am not very familiar with excel charting capabilites can anyone suggest a resorce? Thanks ...
VBA to creating autotext entries or quickparts in different catego
I have a VBA application that basically allows people to easily create autotext entiries, move them between machines and use them making comments on assignments. Currently it operates in EXACTLY the same way in Word 2003 and 2007 (using userforms) and I want to keep that as long as possible. You can see the application at http://emarking-assistant.baker-evans.com and either the screen image or the video demos will give you an idea of what I am doing Currently I store all the comments in a long list of autotext entries that is displayed in a field with the value of the entr...
Opening pub files created with older Publisher versions #2
I have just upgraded to Publisher 2003 from 2000 and am having trouble with pub files sent to me for our chuch newsletter which is using Publisher 97 The text is not wrapping around graphics boxes. Can I fix this? I really don't want to go back to Pub 200 Thank Richard this is caused by Publisher 97 not been printer independent. Even if you went back to Publisher 2000, unless you have the identical font versions and printer driver you would have issues with formatting. It sounds like the person sending you the file has a garbage HP inkjet printer. Get them to install the HP5P laser p...
Page setup for 8.5x11 calendar w/picture on tabloid paper?
How can I set up a calendar with 8.5x11 (landscape) pages with pictures for each month to print on tabloid (11x17) paper so it can be saddle stiched? I would like the picture on the top half and calendar on the bottom half. I keep ending up with two of the same pictures on one page and two calendars on the next page. Thanks, Bob I assume you are taking this to a professional printer so why not just set each page up as a landscape 8� x 11 and let your printer do the rest? -- JoAnn Paules MVP Microsoft [Publisher] "Bob at 4799" <Bob at 4799@discussions.microsoft.com>...
Non-VBA way of making custom menus.
Sorry for the new thread but even on Google, the thread isn't showing up. Well, it was SOOO easy, as I knew it would be. The webpage I quoted in my message this morning didn't mention the "New Menu" at all! So, here is the non-VBA way to create a custom menu: - TOOLS > CUSTOMIZE - under the categories available choose NEW MENU and then drag the NEW MENU option under the Commands window up to the menu bar (like D'UH!! <lol> Wish all those hours spent searching yielded webpages that gave this! <g>) - THEN one can go back to the MACROS category a few line...
Creating Text Box in Publisher 2007 Crashes the Application
Hello, we have a clean install of Publisher 2007 under Windows XP SP2, and when we try to create a text box in a document, (both an existing document and a blank document), publisher crashes. Office is fully patched. I ran Office Diagnostics from the help menu and no problems were found and the issue persists. Any thoughts on how to resolve the issue? Thanks, Syd See if selecting a different printer as default helps. How to view error signatures if an Office program experiences a serious error and quits http://support.microsoft.com/kb/289508/en-us -- Mary Sauer MSFT MVP http://of...
Creating a Macro to Delete Commas #2
I have an excel file that the size will varry. I need a macro that will check all the fields for a comma. If there is one I would like to get rid of it. Does anyone have any idea how to do this? I have no idea and I have been assigned this task. Help --- Message posted from http://www.ExcelForum.com/ No macro required. ctrl-H for find/replace. find , replace nothing (leave the replace field blank). You can of course record that within a macro if you wish. Drabbacs >-----Original Message----- >I have an excel file that the size will varry. I need a macro that will >check ...
Create Exchange mailbox from command line
I'm writing a script using dsadd and I was wondering if it's possible to create an exchange mailbox from the command line. Donovan Maybe not exactly what you want but it may help: http://www.joeware.net/win/free/tools/exchmbx.htm -- Neil Hobson Exchange MVP For Exchange news, links, and tips, check: http://www.msexchangeblog.com "Donovan Linton" <DonovanLinton@discussions.microsoft.com> wrote in message news:D9C839EF-883D-4E2E-8BE9-57782582F043@microsoft.com... > I'm writing a script using dsadd and I was wondering if it's possible to > create an ...
creating a backup on 2002 for Money 98
I am helping a friend who has 98. I need to make a backup of info on my 2002 for him to use on 98. Any suggestions as to how to do this? M98 can't read any file written by M02 besides .QIF import. M02 can't write any file readable by M98 except for .QIF export. Sounds like QIF export/import is your only choice. I suspect you will find this doesn't do what you want. "Carlotte" <Carlotta41@discussions.microsoft.com> wrote in message news:015b01c3d2fa$bbf8fd60$a101280a@phx.gbl... > I am helping a friend who has 98. I need to make a > backup of info on...
copy chart from Excel to Powerpoint
I am trying to copy a chart from Excel to Powerpoint, but the button is grayed out and it won't let me copy it. You can convert the chart to a GIF (a picture) with my Excel Objects converter. http://www.geocities.com/excelmarksway "Hoffperson" wrote: > I am trying to copy a chart from Excel to Powerpoint, but the button is > grayed out and it won't let me copy it. ...
Help! charts disappearing, new charts crashing powerpoint
When i open a presentation the charts vanish...i have restarted, they come back. I try to edit a chart, and it crashes powerpoint after a few clicks. What can I do...whole afternoon going crazy! If you are using v 2007 there is a hotfix which is meant to cure some chart crashing problems http://support.microsoft.com/default.aspx?scid=kb;en-us;976479&sd=rss&spid=11264 -- john ATSIGN PPTAlchemy.co.uk Free PPT Hints, Tips and Tutorials http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html "UKExcelgeek" wrote: > When i open a pres...
Start macro creating a mail with contact data and autotext
Hallo, I am working with an user form. The developing of that form started with Outlook XP with a lot of code inside for different buttons. I changed to Outlook 2007 and unfortunately the code of the form was not longer displayed. What I learned about this is that MS does not support to much code in the form (or maybe a bug). They also do not support any longer. I was sending this form to MS support but they told it is do much code inside and they do not know, why the code is not displayed. In Outlook 2003 the code is displayed as in Outlook XP. Because I do not know real...
SQL query / Formula for Reorder Point?
Is it possible to issue an SQL command(s) that would: 1. Set the Restock Level for all items to be equal to the current on-hand quantity for each item. 2. Set the Reorder point for all items to be equal to 1/3 of that items Restock Level. I'm currently doing this manually, or using a formula in excel when items are initially imported into the DB, but there are still several thousand that need to be retro-fitted like this... Thanx in advance! -=RFM=- UPDATE Item SET RestockLevel=(Quantity - QuantityCommitted) UPDATE Item SET ReorderPoint=ROUND(RestockLevel/3,0) - Evan Culver Ne...
RPC Over HTTP on Single Server
I have installed Exchange 2003 SP1 on a single server and installed and configured OWA. In following KB 833401, it says to add reg. entries to the \NTDS service. I don't have Active Directory installed on the computer. How do I ensure a proper configuration (see below), when this option is not avail. since I did not install AD, as suggested, on the Exchange 2003 server. "Configure all your global catalogs to use specific ports for RPC over HTTP for directory services" HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NTDS\Parameters\NSPI interface protocol sequences...
Text box in Embedded chart is cut off
Hi. I am having a problem with an embedded chart that appears differently in word versus how it appeared originally in Excel. Specifically, the top of the chart (in excel) has a text box that divides the chart (it is a vertical bar graph) into subcategories (labels at the bottom are used to specify what each bar signifies; but these are taken from the associated cell range). Originally, the chart was labeled by a single text box, separated by spaces: Lifetime Use 30-Day Use Heavy Use Antisocial Behavior When this chart is linked in word, the text displays like this (tho&...
difference between 2 lines in a scatter chart
I have created a scatter chart with two lines. The x axis is divided up into 10 parts and labeled 10, 20, 30, 40, etc. What I want to do is calculate the distance between the two lines between the x values of 40 and 60. Does anyone know how to to that? Thank you in advance. -- prd02003 ------------------------------------------------------------------------ prd02003's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25762 View this thread: http://www.excelforum.com/showthread.php?threadid=391727 How did you generate the lines? Are they from the data directly...
Chart help Hide Months
I have a data sheet that has historical data, I only want to chart 13 months instead of all the data. Is there a way to do this? hide em -- Don Guillett SalesAid Software dguillett1@austin.rr.com "lmossolle@nc.rr.com" <lmossollencrrcom@discussions.microsoft.com> wrote in message news:EEF19AB1-9092-4B52-868E-574232FC8AC0@microsoft.com... >I have a data sheet that has historical data, I only want to chart 13 >months > instead of all the data. Is there a way to do this? Hi, If your data increase each month have a look at Jon Peltier's example of dynamic na...
XML Mapping: Creating a "non-repeating schema element" in VS2005
Question regarding XML mapping in Excel. XML Mapping in Excel allows you to map "non-repeating schema elements" to an individual cell while "repeating schema elements" automatically get handled as an Excel "list". I want a table(XML/XSD) exported from a VS2005 dataset to be CELL mappable rather than LIST mappable. Is there a way to make Excel interpret the native dataset XML/XSD as non-repeating? Said differently, what makes a schema element "repeating" versus "non-repeating"? Is it a unique XPATH statement? If my underlying table has...