change range for multiple charts

Hi
I need to change the range for multiple charts, i.e. i have to go chart by 
chart and modify, either with the mouse or by typing, the new range, is there 
a quicker way to do this?
0
Utf
12/8/2009 1:14:01 PM
excel.charting 18370 articles. 0 followers. Follow

2 Replies
1594 Views

Similar Articles

[PageSpeed] 12


"Yossi evenzur" wrote:

> Hi
> I need to change the range for multiple charts, i.e. i have to go chart by 
> chart and modify, either with the mouse or by typing, the new range, is there 
> a quicker way to do this?
0
Utf
12/8/2009 3:34:02 PM
I've written a little Excel add-in that performs mass edits of series 
formulas:

How to Edit Series Formulas
http://peltiertech.com/WordPress/how-to-edit-series-formulas/

Scroll down a couple screens to find the link to the add-in.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Yossi evenzur wrote:
> Hi
> I need to change the range for multiple charts, i.e. i have to go chart by 
> chart and modify, either with the mouse or by typing, the new range, is there 
> a quicker way to do this?
0
Jon
12/9/2009 2:30:51 AM
Reply:

Similar Artilces:

Bar chart help wanted
Hello to everybody ! I have this kind of data: TIME VALUE 0:00:00 0 0:00:34 1 0:00:35 1 0:01:00 0 0:01:30 0 0:01:33 1 0:01:55 1 0:01:59 0 0:02:00 0 0:02:10 1 0:02:15 1 0:03:00 0 0:03:05 0 0:03:07 1 0:03:55 1 0:08:00 0 and I need to create bar chart that would have a bar of the hight equal to 1 at each time value where the "value" in table (Y-axis) equals one (and also between "one"s values). In all other time values the Y value is zero ! Excel bar chart seems to omit all values that are not in the dataset ! I need to include also those time values that are not expli...

Multiple Classes
I have a table that contains all the classes for 3800 students. Each student times 7 gets you around 23000 classes, each record contains: SSN, LocalID, Name, Subject (ELA, Sci, SS, Math are the only ones I care about), Class Level (1,2,3,4), Teacher Name, Period, and Course Name. The problem is, some students will have 2 ELA or Sci classes due to failures, illness, skipping etc. I need to know which is the higher course. No problem, I made a select query, put in SSN, Subject (=ELA), Level (set to Max), Teacher Name, and Period. Nope, didn't work. I still had duplicates because ...

changing Default Calendar and Contacts
I was wondering if there was a way to set the default calendar and the default contacts list in Outlook to be a public Calendar and Contact list that we have using Exchange 2003? Not that I know of. James wrote: > I was wondering if there was a way to set the default > calendar and the default contacts list in Outlook to be a > public Calendar and Contact list that we have using > Exchange 2003? ...

Why subscript out of range?
Hi, why do I get a run-time error number 9 'subscript out of range' message on running this code? Dim vaTest as variant Dim i as integer vaTest = Range("a1:a10").value For i = 1 to Ubound(vaTest) If vaTest(i) = "True" then Msgbox "True" End if Next i ...

How do I get a chart to only display the dates in my table?
I am trying to graph a large group of data. It is a series of dates (not all consecutive) - with the time it takes to do a task on each of the dates. When I graph it - it fills in all the "missing" dates. For instance lets say a set of data would be: Date: 12-1-08 12-5-08 12-6-08 12-6-08 12-12-08 Time: .5 .34 .93 1.2 .25 On my graph it would put a date for every date between 12-1 and 12-12 even if there is no data. Is there any way to have Excel graph only the dates that have data? Change the axis from t...

How do i get my data to be on the x axis of a chart?
Holly - Chart menu > Source Data > Series tab. Select a series, then use the X Values (or Categories, depending on chart type) edit box to select your range of X values. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ hollybusch5 wrote: ...

Gantt chart labels missing
Please forgive me, I hardly ever use excel charts. I wanted to make a gantt chart with time, so I download the gantt template on http://www.j-walk.com/ss/excel/files/general.htm Then I used this article to change it to hours, and amazingly for a Microsoft article it was really helpful http://support.microsoft.com/?kbid=213915 However I now have a lovely Gantt chart in hours, but every other title on the left (the tasks) is missing. I have tried making the font smaller and the chart bigger but that has not helped. I have searched in google groups, but not seen anything similar. I would be ...

Visio 2003 Org Chart Wizard Macro
Hi, If someone could do me a favour it would be much appreciated. In Visio 2003 i believe you can record macro actions, using the record, stop method in Visio itself. Please could someone record the process of going through the org chart wizard, linking through to an Access database, and then either post the code here or send to me. Many thanks, Scott ...

assign permanent colors to bars/values in a pivot chart
I have a column in my source data called "TIER" so the values are 1, 2, 3 etc. when I convert to a pivot chart I want those values/bars to be automatically & permanently assigned a specific color. Eg. Tier 1 = Green, Tier 2 = Yellow etc. Can you help? The colours in a chart are taken from default settings for the data series in the defined order. You can change these default settings in Tools/Options/Color(tab). You see the 56 standard colours and under the thin line the colours for Chart fills and Chart lines. The first series is the left colour, etc up to 8 colou...

Two sheets merged to one changing colour?
Hi If you had 2 or more spreadsheets giving the same info but in different areas, is it possible to merge all the info into one sheet? Week ending dates across the top, left hand side operation bein carried out, cells are coloured in a colour according to area, if it is possible, if an operation being carried out coincided wit another operation would the cells then divide in colour? Hope ive explained the question well tried to keep it simple. I have two small examples here which show in more detail what I mean if anyone is having trouble getting it. Frank...where are you my saviour : -...

How do I stop chart from plotting null values as zeros in excel 20
Blank (null) values plot as zeros in my charts. In excel 2003 I used tools-options-active chart-plot empty cells as but I can't figure out how to do this in excel 2007. On the Chart Tools > Design tab, click on Select Data, then click the Hidden and Empty Cells button on the dialog (bottom left corner). Note that this only works for true blank cells, not for formulas which return "". This is not a blank, but a short piece of text, which Excel evaluates as zero. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, In...

Transpose multiplication
When I multiply two vector arrays, one in a column and another in a row, I do it with the TRANSPOSE() function. Long time ago someone told me that the same thing could be done using simbols in a special way (brackets, may be). I used the method and it worked, but now I can not remember it. It had advantages over the TRASPOSE() function, so if anyone remember how this is done, I'll preciate letting me know. Thanks, Cap Kirk Cap Kirk wrote: > When I multiply two vector arrays, one in a column and another in a row, I > do it with the TRANSPOSE() function. Long time ago someone told...

Using Indirect Cell References in a Chart
I am trying to create a 'self-sizing' chart, but don't know if I can use indirect cell references in a chart. Here's the scenario: I have a tab with data(DataTable! A2:A20) and a tab with Graphs (Graphs). I use a Max formula to determine the last row of data entered, and I've labled that formulas as 'DataTable!LastRow'. In my 'Graphs' tab, I have a cell called 'Graphs! XAxisLabel' with the formula ='Datatable!A3:A'&(DataTable! LastRow)' that displays the rows of data to be used in the chart. I want to use a formula (=Graph...

How do I change the default file of type from shortcuts in the fa.
When opening files via your favourites in Excel 2003, the default file type is shortcut and I can only access excel files by change the file of type each time. Is there a way I can set this function to automatically look at excel files whenever I open up excel? I think these dialogs try to help you by remembering what you did last time. This is slightly quicker for me: Instead of using the dropdown and looking for the excel files, I'll just type: *.xls in the filename box and hit enter. (or even *.xl* if you need .xlt, .xla and .xls....) P.L.Whitehart wrote: > > When open...

Sending Emails Multiple Times Before Its Delivered
Yesterday at different times during the day, I forwarded numerous emails (approx. 7) to one address, using MSN and Gmail in Live Mail 14.0.8089.0726. All the emails were a page, or less, in length and some had attachments no larger than .99 mb. Although all the addresses were the same, inserted from my contact list, some of the emails were delivered and some were returned with the following: "This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed." Some of these emails were finally delivered after emailing them ...

Chart display help
How can I have the chart bars display the percentages and the data labels be the raw numbers? Is this possible? Hi, By default bar charts don't display percentages, however, you could create custom data labels by combing a calculation of the percentage with the actual value in another range and the using a program like the free XL Chart Labeler to pick up that range for the data labels. http://www.appspro.com/Utilities/ChartLabeler.htm Suppose the numbers that are your Values are in C2:C10, create a new column by entering the following formula in D2 =C2/SUM(C$2:C$10) Copy this fo...

Scanning E-mail for Certain words & changing the background
Hello, I have been asked to write a macro for Outlook that will scan an e-mail for select words such as Voluntary, Surrender, etc. and then change the background (highlight) those words found in an e-mail. I have used VBA in Excel and Access but not in Outlook. I looked through all 43 pages on the site and could not find a post to help. Probably looked right past several. Anyway, any help would be appreciated. thanks, -- rhutch In what version of Outlook? Highlight those words in an open message? In the reading pane? -- Sue Mosher, Outlook MVP Author of Micr...

How do I change a symbol to a numeric value ie: N to 5
I'm trying to change symbols to numberic values & not finding any answers. Tools>Autocorrect for an unwieldy method. VLOOKUP table method. VBA event code method. Gord Dibben MS Excel MVP On Wed, 26 Apr 2006 08:57:01 -0700, 7vYkCtVN <7vYkCtVN@discussions.microsoft.com> wrote: >I'm trying to change symbols to numberic values & not finding any answers. ...

adding space between columns in a chart
I am trying to customize a chart and I need to have a group of three lines (for pre-test days) then a space followed by a single line for the test day. I need to be able to accomplish this but also have a legend for these. have you tried having an empty cell in your data series for the space? "merritaf" wrote: > I am trying to customize a chart and I need to have a group of three lines > (for pre-test days) then a space followed by a single line for the test day. > I need to be able to accomplish this but also have a legend for these. ...

How to change alias format
Hello, How do I change alias format in exchange 2010. Currently it's FirstName+LastName and I wish to change it to be similar to AD user ID. Thank you. ...

Selection of date range
I have a small table that covers an entire year of sales I need to make a way to select he date range, and sales Agent type and display the pounds purchased for that week. So I'd like a selection box "enter Date range" (weekly) & type of Customer Affiliate Domestic, Affiliate international, Domestic Customers, International Customers. Should be simple, eh? Any advice? Just add a little form with 2 textboxes: txtStart and txtEnd Then use the following query criteria: For the dates: Between Forms!FormName!txtStart And Forms!FormName!txtEnd...

Return range of cell values based on current date
I have a spreadsheet containing daily sales data for the month. I want today's sales data to display on a different worksheet to save the hassle of someone scanning through an entire month of data. Is this possible and what function do I use to achieve this? Thanks, Wing WHY NOT ADD A WORKBOOK? Providing a workbook will not only get you your answer quicker but will better illustrate your problem, usually when we can see your data (-it can be dummy data but must be of the same type-) and your structure it is far easier for us to give you a tailored, workable answer to ...

XY Scatter Chart with X-axis displays the Category Name
Hi, i am having data like this Code - Qty X - 100 Y - 500 Z - 700, i would like to plot xy scatter graph like in which, X axis shows, all code name i.e X,Y,Z and Y axis shows the values, is it possible ? You've described a line chart. Line charts can use arbitrary labels as X values, while an XY chart requires numeric values. In either type of chart, the series formatting can be the same (e.g., XY charts with lines connecting the points and Line charts with no lines). In this respect, the terminology is confusing. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Cus...

Software Changed symbol for stock and now can not fix
When I turned on Microsoft Money this morning, discovered that the stock symbol on one of my stocks had been changed and it is now reporting completely wrong pricing, etc. How do I correct the stock symbol back to the correct one for the stock? I hope I do not have to delete stock and start from scratch reentering information for the last 4 years........ In microsoft.public.money, basor wrote: >When I turned on Microsoft Money this morning, discovered that the stock >symbol on one of my stocks had been changed and it is now reporting >completely wrong pricing, etc. How do I...

Mailbox size changes does not take effect immediately.
Hi, We are using Exchange 2003, all of our users have a restricted mailbox size. The issue that we encountered is that when a user reached the maximun size of the mailbox, they can't send or receive any email, so we will asked the user to housekeep or increase the mailbox temporally but the time for the increased of the mailbox size to take effect is too long. So how do we make it to take effect immediately ? We did asked the user to logoff and login again or restart their pc but still it did not take effect immediately. Any ideas ? Thank you. Regards, Zul We ran into this as...