Charts and "global" changes

Hello all,
   I'm actually working in Microsoft Access97, which uses MSGraph 2000 for 
charting, so I thought this was really a "charting" question... not an 
Access question.

   I have an XY scatter chart (using just points... no X or Y error bars or 
lines) all laid out just fine, but I have a couple of questions that would 
make my work a lot easier.

   When the data first displayed on the chart, every data point had a 
different "style"... circles, triangles, x's, etc...  I had to go into every 
one individually and change them to a black dot at size 3.
   Isn't there some way to tell the chart that I want that "style" for all 
the datapoints at once??

   Taking that same scenario, can I also globally change all the Data Labels 
"style" (alignment, color, etc) all in one "fell swoop"??

   Any help would be greatly appreciated...

   Thanks,
   Al Camp



0
anon1927 (17)
3/25/2005 3:13:39 PM
excel.charting 18370 articles. 0 followers. Follow

3 Replies
353 Views

Similar Articles

[PageSpeed] 59

Al -

This is sometimes what Excel or MS Graph might do to be helpful. You're 
plotting a single series, right? Double click the series, and on the 
Options tab, clear the Vary Colors by Point checkbox.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

AlCamp wrote:

> Hello all,
>    I'm actually working in Microsoft Access97, which uses MSGraph 2000 for 
> charting, so I thought this was really a "charting" question... not an 
> Access question.
> 
>    I have an XY scatter chart (using just points... no X or Y error bars or 
> lines) all laid out just fine, but I have a couple of questions that would 
> make my work a lot easier.
> 
>    When the data first displayed on the chart, every data point had a 
> different "style"... circles, triangles, x's, etc...  I had to go into every 
> one individually and change them to a black dot at size 3.
>    Isn't there some way to tell the chart that I want that "style" for all 
> the datapoints at once??
> 
>    Taking that same scenario, can I also globally change all the Data Labels 
> "style" (alignment, color, etc) all in one "fell swoop"??
> 
>    Any help would be greatly appreciated...
> 
>    Thanks,
>    Al Camp
> 
> 
> 
0
3/26/2005 10:57:59 PM
Jon,
   Don't know if I mentioned in a previous post... checked out your web 
site.  An excellent Excel chart resource!

   When I highlite one of the values, only that one selects, so I don't 
think it's one series.  The VaryColors checkbox is disabled, and can't be 
set true or false.
   When I first plotted the graph, every value had a different symbol, so I 
think I have many "one value series", so that's why I have to change each 
one individually.
   I was hoping that there might be a way I can set it up so that MSGraph so 
that no matter how many series it creates "on the fly" it will always use a 
black dot to indicate the value, and not triangles, squares, Xs, etc...

   Thanks for your help,
   Al

"Jon Peltier" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message 
news:uqzgCdlMFHA.1176@TK2MSFTNGP15.phx.gbl...
> Al -
>
> This is sometimes what Excel or MS Graph might do to be helpful. You're 
> plotting a single series, right? Double click the series, and on the 
> Options tab, clear the Vary Colors by Point checkbox.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> AlCamp wrote:
>
>> Hello all,
>>    I'm actually working in Microsoft Access97, which uses MSGraph 2000 
>> for charting, so I thought this was really a "charting" question... not 
>> an Access question.
>>
>>    I have an XY scatter chart (using just points... no X or Y error bars 
>> or lines) all laid out just fine, but I have a couple of questions that 
>> would make my work a lot easier.
>>
>>    When the data first displayed on the chart, every data point had a 
>> different "style"... circles, triangles, x's, etc...  I had to go into 
>> every one individually and change them to a black dot at size 3.
>>    Isn't there some way to tell the chart that I want that "style" for 
>> all the datapoints at once??
>>
>>    Taking that same scenario, can I also globally change all the Data 
>> Labels "style" (alignment, color, etc) all in one "fell swoop"??
>>
>>    Any help would be greatly appreciated...
>>
>>    Thanks,
>>    Al Camp
>>
>> 

0
anon1927 (17)
3/27/2005 1:14:47 AM
Hi Al -

Thanks for the nice review of the web site.

When you set up the chart, did you delete all but one column of data and 
then change the numbers? The default chart is set up to chart with 
series in rows. On MS Grump's Data menu, choose Series in Columns, and 
see if that doesn't fix it.

- Jon

AlCamp wrote:

> Jon,
>    Don't know if I mentioned in a previous post... checked out your web 
> site.  An excellent Excel chart resource!
> 
>    When I highlite one of the values, only that one selects, so I don't 
> think it's one series.  The VaryColors checkbox is disabled, and can't be 
> set true or false.
>    When I first plotted the graph, every value had a different symbol, so I 
> think I have many "one value series", so that's why I have to change each 
> one individually.
>    I was hoping that there might be a way I can set it up so that MSGraph so 
> that no matter how many series it creates "on the fly" it will always use a 
> black dot to indicate the value, and not triangles, squares, Xs, etc...
> 
>    Thanks for your help,
>    Al
> 
> "Jon Peltier" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message 
> news:uqzgCdlMFHA.1176@TK2MSFTNGP15.phx.gbl...
> 
>>Al -
>>
>>This is sometimes what Excel or MS Graph might do to be helpful. You're 
>>plotting a single series, right? Double click the series, and on the 
>>Options tab, clear the Vary Colors by Point checkbox.
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>Tutorials and Custom Solutions
>>http://PeltierTech.com/
>>_______
>>
>>AlCamp wrote:
>>
>>
>>>Hello all,
>>>   I'm actually working in Microsoft Access97, which uses MSGraph 2000 
>>>for charting, so I thought this was really a "charting" question... not 
>>>an Access question.
>>>
>>>   I have an XY scatter chart (using just points... no X or Y error bars 
>>>or lines) all laid out just fine, but I have a couple of questions that 
>>>would make my work a lot easier.
>>>
>>>   When the data first displayed on the chart, every data point had a 
>>>different "style"... circles, triangles, x's, etc...  I had to go into 
>>>every one individually and change them to a black dot at size 3.
>>>   Isn't there some way to tell the chart that I want that "style" for 
>>>all the datapoints at once??
>>>
>>>   Taking that same scenario, can I also globally change all the Data 
>>>Labels "style" (alignment, color, etc) all in one "fell swoop"??
>>>
>>>   Any help would be greatly appreciated...
>>>
>>>   Thanks,
>>>   Al Camp
>>>
>>>
> 
> 
0
3/28/2005 4:33:31 AM
Reply:

Similar Artilces:

global macro.xls
I have an Excel file that if I open it on a machine with office 2k not 2k3 and click on cells it gives a message "cant find global macro.xls." No such file exists on my machines, but it works fine in office 2k3. Any thoughts? Interesting. Can you send it to me? You can clear out any proprietary data first it you want. -- Jim Rech Excel MVP "spammeblind" <spammeblind@discussions.microsoft.com> wrote in message news:B5F2A847-73D9-4937-A181-EA7647B667A5@microsoft.com... |I have an Excel file that if I open it on a machine with office 2k not 2k3 and click on cel...

Custom Global address List.
Is it possible to make a custom GAL for specific groups. So I can filter what the user can and can not see in this list. Like contacts for finance are not displyed in a list for a normal user. -- Regards, Ron On Sun, 27 Feb 2005 10:55:05 -0800, "Ron Dokter" <RonDokter@discussions.microsoft.com> wrote: >Is it possible to make a custom GAL for specific groups. So I can filter what >the user can and can not see in this list. Like contacts for finance are not >displyed in a list for a normal user. If you actually want to remove the visibility of internal users the...

Global Address List Not Updating
On Exchange 2003 Server the Global address list does not update when users account is deleted or spelling is changed. It will update when adding new users, but old accounts and if spelling is changed the address list does not reflect changes. Any idea on how to address this? Thanks Dave ...

globally add a privacy note to all e-mails
How can I globally adda confidential and privacy note to the bottom of all e-mails created in outlook 2000,2002 using ms exchange 2000? Please advise. Hi Laura, Have you tried using: Tools, Options, Mail Format, Signature Picker? That will definitely tack something at the bottom of each email. I use it at work to include my name, title and phone number. But I suppose it would work if you typed your confidential privacy note too. Mia :) >-----Original Message----- >How can I globally adda confidential and privacy note to >the bottom of all e-mails created in outlook 2000,20...

nested global group
Hello Exch 2k3 AD 2k3 Mixed Is there any way to nest another group or object in a global group? I realize you can nest global groups into a domain local group. I have a group that needs to be global to be seen by a 3rd party app (websense) but i need to nest other groups in it. Or somehow get those other groups to be mailed when the parent is mailed. Going native isnt a option right now, but it would solve the problem. On Tue, 8 Nov 2005 08:22:12 -0800, "Eric - ARUP" <EricARUP@discussions.microsoft.com> wrote: >Hello >Exch 2k3 >AD 2k3 Mixed > >Is there...

Global variables question
This is probably a really silly question but, I have been bitten by less silly situations so, here it is. Is my assumption correct that all vba code, including global variables, has scope only in the individual FE file that is running it? A global var set in one FE cannot be affected by the same global var being set by another operator in a different copy of the FE file? Silly or not, thanks for your time. Jim Jim Evans wrote: >This is probably a really silly question but, I have been bitten by less >silly situations so, here it is. > >Is my assumption ...

Edit Inbox Messages (global setting)
Under Outlook 2003 I can edit incoming messages by clicking Edit / Edit Message. Is there a way to make this a global setting so that ***all*** incoming messages can be edited without further action, as was the case in Outlook 97? No, and with good cause. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After furious head scratching, Pegasus (MVP) asked: | Under Outlook 2003 I can edit incoming messages by | clicking Edit ...

Customer types for global customers
We're using global customers wtih HQ manager (1.2.171). Is there any way that we can set customer types for reporting purposes. It seems that functionality (user defined fields) disappears from store operations when you go to using global customers. Any work arounds? Thanks for any input in advance. ...

Changing windows control look-n-feel (globally)
I'm working on customizing the look-n-feel of our application to be somewhat like XP and Vista (basically flatter with hover effect, etc). Getting the controls to owner draw is one part of the problem. I'm making progress on that. But if I want to make this happen globally so that default dialogs like the AfxMessageBox, scrollbars, buttons and other controls are changed I'm going to have to subclass everything. Short of going into everyplace these controls are referenced what can I do? I'm assuming there has to be some way to basically hook and replace the stan...

OWA Not Seeing Global Address List
Hello, It was recently brought to my attention that users cannot access the Global Address List through OWA - I myself checked with my own account and it is true, no listing of internal addresses available. Any ideas on where to start looking? -- Bill Smedburg IT Manager Stihl Southeast, Inc. bill@stihlse.com I'm not sure what you mean but there is not a GAL listing as you find in Outlook but there is search functionality for addressess. There are 3rd party products that will provide functionality similar to Outlook. Nue "Bill Smedburg" <bill@stihlse.com> wrote in ...

How to make global changes to charts
Hi I have had occasion to make spreadsheets with 30 or more charts. I have needed to make the same change on all the charts, such as changing the x-axis label. Is there a way to do that all at once (all changed to the same thing) or must I tediously change each one at a time? Thanks Hi Rick, If its the x-axis label the easiest solution is to create the charts initially with the label referencing a spreadsheet cell rather than being hard coded. When you want to update all the labels you would just change the entry in the cell. All charts would use the same cell reference. How to ref...

Global Accept List
Using -- Windows 2003 Standard & Exchange 2003 SP2 I am having a problem, since my last update, with my RS/6000 sending messages. Before that all worked correctly! All messages are ending up in the IMF Archives? If I put the IP address in the Global Accept List (Rs/6000 not mail server) will it force the messages to be accepted? Do I use the internal Static IP of the RS/6000 or do I use the From: IP address - which is our registered domain? Thx On Fri, 16 Mar 2007 08:32:52 -0500, "John Leonard - Sage" <sagegrp@adelphia.net> wrote: >Using -- Windows 2003 Stan...

Global change an embedded link
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Power PC How do I do a global change of every instance of a hyperlink address within multiple Word files at the same time? That's what your web editor is for. Publish the website, and globally-replace the hyperlinks with that. Otherwise, you would need to fire up your AppleScript coder and have at it. The hard bit is opening each Word document: once you have that done, you can change hyperlinks with a Find/Replace. Make sure you view the Field Codes in the document, because Find cannot change what it canno...

Global Address List #32
We have an Exchange 2003 Setup. When people look at the Global Address List they can even see outside contacts. Lately our employees have been sending information by accident to outside contacts that they have clicked on. Is there a way to have the external contacts not show up in the clients GAL but still be in AD for use with Distribution Lists? We have many contacts so I was hoping there is a way to set it in one location and not have to go through every contact checking a box. Thanks. It sounds like you are attempting to hide a contact from the GAL? If you get Properties of a contact t...

Global IME with Office 2000 & Windows XP
I would like to install Global IME for Office 2000. When I install Global IME 5.02 it not work because I'm using Windows XP platform. When I install Global IME for Office XP it need Office XP to be installed. Can you all please give me the solution on this matter. Regards. Ismail Rahim ...

global changes from alpha to numeric
I have large strings of numbers that need to be keyed into my worksheet and in order to save time, would like to assign an alpha character so I can just go back and do a "Replace All" by changing the alpha back to the string of numbers it represents. It works okay if there are less than 10 digits in the column but once I exceed 9 digits, it changes the number to look something like this - 1.000000+E14. I don't know if there are limitations or not but if anyone knows how to make this work, it would greatly reduce the need to data entry a large amount of data. Thanks! Jeff jda...

Globally delete exchange meeting?
A user deleted global recurring meeting in exchange without sending update, now all other users are stuck with this meeting even though it's gone from organizer's calendar. Is there an easy way do get rid of this meeting globally for everyone? Thanks, Tom ...

Global Address List Permissions HELP
Hi, How/where do I give a certain user permission to add to/create/edit the Global address book through outlook?? I've given myself (for testing purposes)full control of the Global Address List Security in Exchange but still am unable to create a new Distribution Group in the Global Address list... "You cannot create entries for this address book" Thanks for any help. ...

Cannot see receipients in global list while using OWA
I have exchange 2003 with outlook 2003 as client. Whenever I use OWA and try to create new email and click on TO to select receiver's name from the global list, I get a differnent screen which as me to enter name to search. I want to display names so I can select from the list. Here is the screen that I get each time I click on TO. I should be seeing everyone's name so I can select. If I connect locally, I do get the list and there is no problem. This happens only with OWA. Thanks -------------------------------------------------------------------------------- OWA d...

Restoring hyperlinks globally??
A friend in a yahoo group just wrote that she recvd a workbook full of hyperlinks that don't work. It's as if someone removed them or something. The only way I know how to do this is to copy the link and right-click in that cell and then to choose hyperlink from the context menu and to paste that link into the appropriate box in the "Insert hyperlink" dialogue. But was hoping someone knew of a way to make _all_ the links active all at once without doing the above? Thanks. See one response at your other post. StargateFan wrote: > > A friend in a yahoo group just ...

Accessing global variables in EXE from DLL
Is there any way I can access the global variables declared in the EXE file from a DLL? Thank you Abhijit No. And it would be a truly lousy idea to try to do so. The word "Modularization" comes to mind. You could pass pointers to these variables in, but frankly, it strikes me as exceptionally poor practice to do so. If the DLL needs state, the state should come in via a pointer to some class that defines the DLL context. The usual reason for this question, by the way, is most often trying to partition poorly-written code into a DLL, where the poorly-written code uses global varia...

Exchange 2003 loses connection to the global catalog server
Anybody have any help with my mail server losing a connection to the global catalog server. I reboot the server and everything seems to work fine for about a hour then it loses the connection again to the global catalog server. I am still able to ping the server after it loses its connection to the global catalog server. So it seems as if the it is not losing the network connection. Any one have any ideas? James Is there anything in the event log? Which server are you rebooting? -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "cubby1977...

Changing chosen numbers globally via popup
Hi I have a small task to carry out in Excel. I need a macro that will offer popups requesting the following a. Choose a column to operate on. b. Enter a number to be found in that column. c. Enter a number to update the number chosen in b. d. Go back to start of macro at popup a , unless cancelled. So , I might choose column D , all values at 7.30 to be updated to 12.50. Can someone help with some code , please? Grateful for any assistance. try this Sub replacenumber() Do OldValue = InputBox("Enter Data to replace : ") NewValue = Inp...

Global
We are using Exchange 2003 Server, How to Access Exchange Global Address list for POP3 and SMTP Client waiting for your reply Regards Sathish kumar Sathish Kumar Nair <SathishKumarNair@discussions.microsoft.com> wrote: >We are using Exchange 2003 Server, > >How to Access Exchange Global Address list for POP3 and SMTP Client You don't. Use LDAP to query the Actve Directory. -- Rich Matheisen MCSE+I, Exchange MVP MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm ...

hyperlinking to an item in Global Address List
I have figured out how to hyperlink (html) to an item in my contact list: outlook:Contacts/~John Doe This works great. Now I would like to be able to issue a command to open a specific contact from the Global Address List. It is possible that the Global Address List has some folder name like GAL so that a command like this: outlook://GAL/~John Doe could be issued. Does anyone know how to refer to the Global Address List by its folder name or to do what I am asking? This can't be done, but you can add the GAL entry to your contact folder and then do what you know. Is that good en...