Graph reverse order changes series order but not legend order

Hi,

If I change the order of a graph in the axis properties the order o
the series is reversed as well as the order of the data, but not th
order of the legend. Is there any way to reverse the order of the grap
and keep the series order synchronized with the legend order beside
rebuilding the data set backwards?

Thanks,
Aaro

--
Message posted from http://www.ExcelForum.com

0
8/13/2004 11:48:37 AM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
427 Views

Similar Articles

[PageSpeed] 34

Reply:

Similar Artilces:

Print pages in collated order
I have a program that I am putting together...it allows a user to use a ToggleButton to print out a variable number of pages depending on how many products have been chosen. The problem is when the pages print, they come out by individual product, not collated sets (e.g., if I want to print six copies of each product it will print out six copies of product number one, six of number two and so on). I want to be able to print them in order (e.g., one of product one, one of product two, etc…so that eventually six full sets are printed out). Here are the string of commands that I have so far...i...

Make lines on a graph appear with a button
All, I need to create a graph with 40 or so lines graphed but only one up o the graph at a time with the use of buttons. I would really appreciat a hand, I am very new to this level of Excel. Thanks -- Message posted from http://www.ExcelForum.com Select all the data, and create a line chart Select a cell in the table Choose Data>Filter>AutoFilter From the dropdown list in one of the heading cells, select an item The chart will display the data for that item geistritter < wrote: > I need to create a graph with 40 or so lines graphed but only one up on > the graph at a tim...

how can I change the size of each cell consistency?
how can I change the size of each cell consistency? I mean width and height of each cell. Thanks!! Hi Matthew, You can't change the size of an individual cell. You can change the width of column(s) or the height of row(s) - to a specific width - to autofit a selection. Column selection(s): Format, Column, width, specify width or autofit a selection Row Selection(s) Format, Row, width, specify height or autofit a selection You can double click on the border between two column headers or between two row headers to fit row or column to selection. If you want a program...

XY scatter graph
How do I attach dates to data points when the x&y values are not dates? Hi, One way is to use Rob Bobey's free addin, Chart Labeler. http://www.appspro.com/Utilities/ChartLabeler.htm Cheers Andy gps tech wrote: > How do I attach dates to data points when the x&y values are not dates? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info ...

Prediction Graphs
How do i make a graph predict the next value from 3 tables with info eg Table 1 has 5$ profit Table 2 has 3$ profit Table 3 has 8$ Profit how do i make a graph which predicts the next set of values from these values? -- peabushmartin ------------------------------------------------------------------------ peabushmartin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27399 View this thread: http://www.excelforum.com/showthread.php?threadid=469414 The mechanics of getting a chart to predict future values is easy. Chart your data in the desi...

Corporate Name Change
How does one change the name of a stock (and symbol) when a company (such as AOL) decides to do so Wade: Select AOL from your portfolio, right click and choose "see details" You can rename it and change the symbol there. Kevin "Wade" <anonymous@discussions.microsoft.com> wrote in message news:023701c395d4$c6129da0$a401280a@phx.gbl... > How does one change the name of a stock (and symbol) when > a company (such as AOL) decides to do so Thanks ... I get an error stating the ticker is already in use. How can I get around this (is there a global ticker li...

Changing Time To Different Timezones
Hello, I am a new user having just acquired excel 2007 and would appreciate any help. I have a column of dates along with time in CST. I live on the west coast and would like to have excel convert the time part of each entry to PST, or maybe jump to EST. How do I do this. The columns are in this format: 2/28/07 9:20 3/4/07 9:20 3/8/07 9:20 Going down the columns, the dates change but the time is constant with the example showing 9:20 am. It would be nice to have a selector button with the choice of 0 for CST -1 for MST -2 ...

Work Orders #4
Ok lets see, where to start... The scenario is.. The customer at the store is buying two items. One he will take home with him now and the other will be shipped. We would like to be able to make a payment for the shipping. The shipping carriers have been defined and we have a 'by weight' situation table setup. What is the best facility/procedure for this? (Layaway, Work Order?) Can we make a payment on this without shipping or picking up the final item? What is the impact and procedure if we want to return the 1st item and use the already recieved payment for the balance of item ...

Graph within a graph
I am looking to have a pie chart show general information and then have another pie chart show a section of the origional in greater detail. Is this possible? Have you tried using a Pie in Pie chart? "Jen Kulak" wrote: > I am looking to have a pie chart show general information and then have > another pie chart show a section of the origional in greater detail. Is this > possible? That is what I am trying to figure out how to do. I know where the option is, but for some reason I cannot figure out how to enter the data correctly. "Barb R." wrote: &g...

Change closing amounts after Z
Probably a stupid question, but one of my cashiers closed the register without entering closing amounts and now our Z report reads that we were short. Does anyone know of any way to go back and change those totals, after a Z has been done? -- Jen Jen: Not a stupid question. if it was, there would be a lot of stupid people asking that same question. To answer your question in short - it's not easy. You have to get into the guts of the database and make changes via SQL. These changes need to be made in several places. Unless you are very comfortable with database administration, I ...

sales graphs
How can I create a graph that would show sales/dept on the Y axis and years or months on the X axis? use a pivot chart/table in excel. You must create a datasource forst. "irene" <anonymous@discussions.microsoft.com> wrote in message news:260801c5113c$6dd4a6d0$a601280a@phx.gbl... > How can I create a graph that would show sales/dept on > the Y axis and years or months on the X axis? ...

Input value changing on refresh
Hi, I am working on a budget system. The user can apply a budget by month against an account or by year and apply a spread which distributes the total by 12 i.e. 120 so 10 in each month. There are two option buttons. One for by month and one for by year. There are 13 text boxes underneath running from left to right. The months start at April and end in March. The 13th box is the total. The bug is that when you enter data and choose by year and then decide to change a month, when you switch back to by year the total has not updated. The data in the months are correct though. When you...

Resizing Graphs
I have problems with Excel when there are tons of graphs i hve to create with all the graphs being on one page. Having to resize all of them when they are all ALREADY different sizes is a pain. I know how to hold down the control key and select them and resize them all at once, but some or still larger than others unless i resize them individually. Is there a way to make them all the same height adn width some how? or is this just a dream? Must i resize all of them individually? I personally use an add-in (.xla) which includes the following code (you can pick up the size of a chart with ctrl...

How to change Me in contacts?
I've duplicate entries of my name in Contacts. If I go to delete one of them I get an error message that says that entry is designated as "Me" and to select another entry in the contact menu and designate that as Me. I can select another entry, but I don't see the menu where you designate it as Me. Can you help? Ken > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3211449061_1620476 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: 8bit On...

Creating a Line graph
I have data that I want to put in a simple line graph: The data is A B 23 200 87 500 I mark the 6 cells, select insert chart / line and get a chart with both A and B labels on the x axis. I go to "select data source" and try "switch row/column" and get A and B as series names in the legend. How do I get the label A and the values 23 and 87 on the x axis, and label B and values 200 and 500 on the y axis please? (Congratulations Microsoft for making something that was so easy and powerful in Excel 2003 an absolutely primitive disgrace...

Event 8213 Error code: 0xc007052e after changing administrator pw
I am getting event Event 8213 Error code: 0xc007052e on my exchange 2003 server. This started after we changed our administrator password. Is there somewhere that I cas update the password? "RaptorsFan" <RaptorsFan@discussions.microsoft.com> wrote: >I am getting event Event 8213 Error code: 0xc007052e on my exchange 2003 >server. This started after we changed our administrator password. Is there >somewhere that I cas update the password? All of the Exchangeservices run under the Local System account. Changing the password of a user should have no effect ...

Graphs on Forms
I am having a problem getting a graph to display the variables along the right axes. The graph sits on a form which is linked to a parent query. The graph's information comes from a separate crosstab query that is linked to the form via fields from the parent query. The graph fields are day (horizontal axis), race time (Y-axis) and race distance (series field). Unfortunately MS Graph automatically plots the day field as series and the race distance on the X-axis despite the fact that in the crosstab query, I have assigned 'day' as a column heading, 'race distance' as ...

How can I control the order of boot seqence
I have a (sticky-note like) program that loads at startup and stays in the system tray. It loads just fine if it loads early in the boot sequence, but if it loads toward the end, it leaves its tab in the task bar. The only way to get rid of this is to right click the icon in the systray, choose about (which opens a box with the version number) and click the OK on that box. I know this isn't really a big problem, but just annoying. Is there any way that I can control the order of the boot sequence without resorting to third party software? I'm running XP Pro SP2 with ...

joining data points on graph
I am merging two graphs and one has 23 data points, the other has 9. The category axis will have 23 data points but the 9 points are spread out, i.e. they may be at points 1, 3, 7, 15 etc of the 23-point scale. At the moment the graph will only join points that are beside each other; how do I get them to connect to the points that have spaces between them? minihana wrote on Fri, 10 Feb 2006 11:29:04 -0800: m> I am merging two graphs and one has 23 data points, the m> other has 9. The category axis will have 23 data points but m> the 9 points are spread out, i.e. they may be...

help with changing sumif to sumproduct
Hi, In ExcelXP this sumif formula is not working and so I thought to try and change it to a sumproduct but I have been un-successful in several attempts to reconstruct it :-( The issue is the sunif will not sum the values in more than one column as in I need the values in columns N and O summed and the values in columns R and S summed. =(SUMIF('PIP '!$A$9:$A$150,"Jan",'PIP '!$N$9:$O$150))/(SUMIF('PIP '! $A$9:$A$150,"Jan",'PIP '!$R$9:$S$150)) thanks bobh. On Aug 10, 7:33=A0am, bobh <vulca...@yahoo.com> wrote: > In ExcelXP th...

I have to compare two sheets for changes
Hi I have to try and compare 2 sheets and highlight the cahnges, what is the best way of doing this in VBA, I was going to try and do it cell by cell but I was wondering if there was a quicker way?. Any help would be much appreciated. Regards Charles Maybe you can make use of conditional formatting, e.g. if you want to compare newsheet to oldsheet which is an earlier version of newsheet, then apply CF on newsheet! Select A1 then select used range on newsheet and create CF with formula =A1<>oldsheet!A1 Choose a pattern and press OK! -- Regards! Stefi „vqthomf” ...

Automatic Graphs/ Dynamic Graphs
I have a list of test results, one row for each participant. (Each result is in a seperate column) I need to make a graph of all of their results when I click on their names. Obvously I cannot create a graph for each one, as there could be hundreds of participants, I need it to create a graph using relevent cell references for each person on the fly. I have seen this done in the past, but am unsure on how to accomplish this myself. Thankyou for any help you can give me Dan Hi, Maybe you used one of these sites previous to get your information. http://peltiertech.com/Excel/Charts/Dy...

Order in court!
Me and some dude are writing a MemoryLeakTracker. It works pretty damn well, but we have a problem: (it's encapsulated in a single class, and i overrided the new/delete GLOBAL operators and used some macro trickery) How can i assure that it's constructer will happen BEFORE ALL other global variables classes constructers, and that his destricter will happen AFTER ALL other global variables classes destructers? I'm really stuck on this one so if you can help, or need some more clarification on my problem JUST SAY ;) thanks for your time. ZeDuS wrote: >Me and some dude are ...

Change color of "selected" (highlighted) text in Word 2008 for Mac 05-17-10
"Selected" text is in a light blue color, which is difficult to see against the white background. Is there any way to change this color to a different color which is more easily visible? Thanks. Previously answered. See the thread you started 16/05/10 17:35. --rms www.rmschneider.com On 17/05/10 07:58, Eric74 wrote: > "Selected" text is in a light blue color, which is difficult to see against > the white background. Is there any way to change this color to a different > color which is more easily visible? > > Thanks. In articl...

Drawing Graphs
Hello, I would like to create an application that displays one or more graphs on tabbed pages in a single window. These would be straightforward XY coordinate line graphs of the type you would typically see on the face of an oscilloscope. Although my experience with MFC has been sporadic and minimal, I don't want to buy some 3rd party package to do this. While I could do this the hard way (i.e., get out my copy of Prosise's book and start reading), I was wondering if there is a standard class already in existance to do this, or maybe some standard Windows functions. When...