Sorting Chart Legend To Match Source Data Order

Feb 23, 2012

The order of entries in my chart legend make no sense to me. Why is it not matching the order of the source data?

View 1 Replies


Change Order Of Chart Legend Freely

Sep 25, 2007

see this example of a chart: see Image1.gif (the right thumbnail) as you can see 2 different types of graphs are combined: "lines with markers" and "clustered column".

in the legend one can see that the order inside the legend is clustered by the two types. within a type i can change the order easily (right click on a line or column - format data series - series order - up or down).

question: i would like to change the order freely. how to do this? for the order inside the legend i actually do not care at all, whether a representation of the data is a line or a column. i only want to make it as readable as possible. example what i'd like to get (made by handmodifing the picture with a drawing program): see Image3.gif (the left thumbnail)

View 2 Replies View Related

Series Order In Legend, Multiple Chart Types

Aug 4, 2006

I have a chart that combines 2 xy plots and a set of stacked columns ( total of 4 series).

I can adjust the series ordering between the 2 xy plots, and between the stacked columns, but not for all 4 at the same time.

I'd like the legend to show up as:

Series1, Series2, Series3, Series4

where 1 and 2 are the xy plots and 3 & 4 are the components of the stacked columns.

It is currently:

Series3, Series4, Series1, Series2

Any idea how to re-order the legend entries?

View 9 Replies View Related

Rearrange Slices Of Pie Chart In Descending Order Without Sorting Data?

Aug 27, 2013

How to rearrange slices of pie chart in descending order without sorting the data?

View 1 Replies View Related

Excel 2007 :: Source Date Sorting Into Format Used For Pivot Table / Chart?

Sep 24, 2011

I am stuck trying to sort data that looks like the following, into a format that I can use as source data for pivot tables/charts.

DateArticleContentLapseCurrentCurrentCurrentLapseLapseCurrentCurrent612-SepRelieving 40 years - Oct 15, 1972
Thick Haze continues to blanket MalaysiaHistory42712-SepRelieving 40 years - May 5, 1972
All Sharifah wants is a pair of legsHistory1222812-SepA man and his agonyHistory3223912-SepA lesson on Sept 16History22Sheet2

I will need to group Data multiple ways. However, I cant work out a good way to sort it. Can I have a suggestion on layout that I will be able to arrange data appropriately.

View 2 Replies View Related

Legend To Go In Alphabetical Order,

Mar 2, 2009

For Instance i might have a cell with the value 30KDPA

the one right below this needs to be 30KDPB

then 30KDPC

basically the last letter is going through the alphabetical order. Once it hits Z it should go to AA, AB, AC . Just like an excel file.

If i select the first cell and just drag it down it copies that exact same cell value.

View 5 Replies View Related

Add Chart Legend

Jul 30, 2007

how can I add an legend entry that has been removed by error?

View 3 Replies View Related

Dynamic Chart Legend Using VBA?

Jun 28, 2005

I am creating a chart where the number of data series used on the chart will change every time the code runs depending on what information people are looking for. That part works fine. I need a legend that shows which data series were added to the chart. Is there a way to get a dynamic legend on the chart that matches the data series, without manually adding it?

View 6 Replies View Related

#Ref Error In Chart Legend

Dec 18, 2008

I'm running Excel 2003 and I'm getting a #REF error in the legend of a chart! It displays the #REF and then the label. Anyone any idea what causes this - I can't find anything in Help.

View 2 Replies View Related

Standard Legend In Chart

Jul 2, 2006

I want to include a legend to a bubble chart in the folowing format: the smallest bubble in this legend should represent values between A and B, the second (somewhat bigger bubble) should represent values between B and C,and so on. Is it possible to produce a standard legend in a bubble chart?

View 2 Replies View Related

Different Fonts In Chart Legend

Jan 15, 2007

I have a chart graphing different series, which includes a legend to label each series. The labels are linked to particular cells in the worksheet.

Most of the chart has Arial font formatting, but I need to change the formatting of a few characters in the legend:

I know that i can change the formatting of the whole legend, and even different entries in the legend. Is it possible to change the font of just a couple of characters in one legend entry?

Elements I need to change are:
Font type (eg from arial to symbol)
Size (varying from 8 to 14)
Bolding etc.

View 4 Replies View Related

How To Get Chart Legend Back If Deleted

Apr 8, 2012

So i deleted a chart legend - is there a way to get this back or do you have to start all over again?

View 4 Replies View Related

Change Title In Legend On Chart?

Jul 31, 2014

How do i change a title in legend on a chart. i.e. I want the label to be MGRS 2%

Job Category
Category %
EE Total




View 2 Replies View Related

Set Source Data For Chart Using R1C1

Mar 9, 2014

Everything else in my macro is using R1C1 format for ease of automation. However, I cannot get this to resolve. I am setting the source data for a line chart.

However, if I use A1 format it works just fine.

I am using R1C1 for automation purposes. A1 format will not easily work. I have the interpolated statement in there because the range contains some empty cells. I want excel to fill the line in the chart using interpolation. All the data in the columns(N through R or 14 through 18 in R1C1 format) is contiguous. I have not tried Union, but it seems I should just use this range like I do in the A1 format.

View 6 Replies View Related

Manipulating Chart Source Data With VBA

Aug 8, 2007

I have a chart that I am trying to set up with dynamic data. I have the chart created, but the problem is that I will have a variable number of categories based on the data that is loaded, so I need to use VBA to change the range for the source data and labels on the fly (otherwise, I will end up with 20-50 categories that are all zeroes, putting a bunch of gobbledegook at the top of the chart).

What commands to I need to enter into VBA to get this to work?

I have put a formula in 2 cells to determine based on the current data what the source data values range should be, and what the category labels range should be.

The cell that holds the value range is Graphics!L6, and the cell that holds the labels range is Graphics!L7.

The current values that these cells hold are:

Oh, and the name of the chart is "Chart 1"

What do I need to put into VBA to get the chart to change the data source values and category labels to the ranges I have listed in those 2 cells? (and for that matter, have I listed the ranges correctly in those 2 cells so that they are usable?)

If possible, I would prefer to do this without having to use code to select the chart, because I want the updates to the chart to be invisible to the user.

View 9 Replies View Related

Chart Not Reflecting Data Source

Jun 29, 2006

In my table I have rounded my values to a particular number of decimal places. BUT, the bars of my chart have the length of the original numbers. This is especially ridiculous when in the table there are only (rounded) zeros, and in the chart I get several bars with different length. how to plot the bars in the same length as the numbers in the table are?

View 9 Replies View Related

Chart: Selectable (ddl) Data Source

Aug 10, 2006

I have a sheet with logged test data.

Various test items are stored in columns.
(First row of each column is the description of the test item)

1) To reflect certain testdata in a chart I want to be able to select a different column (Y values) by means of a dropdownlist.
X values are just the number of items (1 to ...)

How to make the charts data source selectable?

2) It seems that the input range of a ddl should be a list of items.

In my case they are in the first row of each column so only the first item is shown.

View 5 Replies View Related

Chart With Changing Source Data

Aug 11, 2006

I am trying to create a macro which will allow me to change the source data for a particular chart. what i want to do is to have a code which looks in a range of cells (A8:B28) and then updates the chart to only include those cells within the range that contain a value? The number of cells with values changes depending on what options are selected elsewhere in the spreadsheet.

View 2 Replies View Related

Dynamic Chart Source Data

Jul 27, 2007

In a workbook that I am working on, a macro runs to import data onto 9 separate sheets. The data is essentially x- and y- coordinates of a plot profile from another program. The problem that I am running into is that the number of data points can vary each time the data in imported based upon how the data was acquired.

If I were to put a drop-down list (Method1, Method2, Method3, etc.) on the Instructions page that I have for this workbook and have the user select which method was used prior to running the macro, could I then incorporate some sort of IF statement in the macro to vary the Source Data Series for the charts that I have created? Right now, I have the Source Data covering the scenario with the longest list of data points so when fewer points are used, the graph looks essentially useless.

View 5 Replies View Related

Change Chart Source Data From Add-in

Aug 9, 2007

I have an excel addin that contains chart templates. Without going into too much detail a user will select an option which will update these templates then move the charts along with the source data to a new workbook. My question is this; How do I change the chart references programatically so that the chart data now points to the source data in the new workbook.

View 5 Replies View Related

Chart - Only Show Legend Elements With Values?

Nov 22, 2013

I have 10 graphs with more than 20 legend entries. However, each graph only needs 3-4 elements out of the 20 legend entries in the graph. Is there any way to force Excel to only show those legend entries that have a value? (without deleting them manually)

View 12 Replies View Related

Excel 2010 :: Labels For Legend In Chart?

Dec 16, 2011

I have a chart with 20 series labels that are series 1, series 2.... etc. I want to label them with 20 corresponding cells but can't find how to do this in Excel 2010 (I seem to remember this being easy to do in older versions). At the moment I am having to click on source data and edit each label individually... Is there a quicker way?

View 2 Replies View Related

Legend Overlaps The Plot Area Of Chart

May 4, 2007

I have charts that needs to be placed on specific position and have specific sizes on a chartsheet. I use chartobjects(i).plotarea (top, left, width, height) for that.

Unfortunately when I set these values they still change and get antoher value, there is some scaling going on in Excel and I do not know where that comes from. I have been looking on the internet and finally I found a piece of code which works, but still not good enough, because the legend is also not good positioned.

De data for resizing the charts (ChtNew), the legends and the charttitle I get from other charts (ChtOrig). The legend.legendposition of ChtOrig does not have a value but it still have a top,left,height en width which I use.

I show you my code, the part with the for-next is taken from the internet.

With ChtNew.legend
.Top = ChtOrig.Legend.Top
.Height = ChtOrig.Legend.Height
.Left = ChtOrig.Legend.Left
.Width = ChtOrig.Legend.Width '* 1.1
.Top = ChtOrig.Legend.Top + ChtOrig.ChartTitle.Top
End With

View 9 Replies View Related

Color Chart Data Points By Cell Values Of Non-Source Data

Apr 14, 2008

I have a bar chart that was made from table 1 which has the value in it. I have another table, table 2 that has the name corresponding to the value in table 1. I want to color data points in a bar chart with a different color for each name I have in table 2. I also want to give a data label in the data points with the value I have in table 2 instead of the original data label from table 1. Is it possible to do it?

View 3 Replies View Related

Enable Editing Chart But Not Source Data?

Mar 18, 2014

is it possible to unlock a chart but then disabling to change the source data?

Background: I want the user to be able to add numbers etc. but he shouldn't see the underlying table...

View 2 Replies View Related

Chart Source Data: Union Of Every N Cell

Sep 19, 2006

I have 4 sheets. In each sheet, I have a column of data for every hour of every day of one year.

In the 1st worksheet, I want to make a chart using :

- for Y values : the average of the data for each day
- for X values: the day

In the 3 other worksheets,
- for Y values : the data for each hour
- for X values: the hour

To make it more simple, I will first build in the "D" column the data of the average data for each day (so, every 24 columns)

Here is my

Dim lNbSheet As Long ' sheet number
Dim rSheetData As Range ' what will be my Y values
Dim rSheetTime As Range ' what will be my X values
Dim sSheetName As String ' current sheet

For lNbSheet = 1 To 4

'selection of the Y values
sSheetName = ActiveSheet.Name

I get the error "methode SeriesCollectiosn of Object _chart failed;

Also, if you have an idea that could make me avoid writing all the new average-for-the-day data in column D (using it directly),

View 8 Replies View Related

Graph & Chart: Data Source Changes Monthly

Nov 19, 2006

I am trying to write a macro that will automatically change the source data for a graph. This is an existing graph that is on tab GraphYTD and the data for the graph comes from DataYTD. The number of rows of data will change monthly, but I would like to use the same graph template every month. Here is my

Sub SortYTD()
Dim myBottom As Long
myBottom = Sheets("DataYTD"). Range("B65536").End(xlUp).Row
ActiveChart.SetSourceData Source:=Sheets("DataYTD").Range("F2:I" & myBottom)
ActiveChart.Location Where:=xlLocationAsObject, Name:="GraphYTD"

End Sub

I am getting Runtime error 91 - object variable or with block variable not set.

View 3 Replies View Related

Link Spinbutton To Chart Data Source

Nov 21, 2006

For example, if my graph currently shows B1:L1 range, how by clicking a spin button to make the graph show B2:L2 range?


View 9 Replies View Related

Changing Chart Source Data Range

Nov 30, 2006

Each week I have to add a new column to a report and then update the source data of all the charts that use that newly added column. I am trying to create a macro that will use the last 12 columns of data located on a different worksheet as the range for the source data of the chart. I have attached an excel document that contains an example of how one of the charts that I am using looks and where it pulls the data from.

View 3 Replies View Related

Code To Change Chart Source Data

Jul 16, 2007

I am in the middle of building a macro for some data to be automated. I have two sheets, one of which has an existing chart but the data has been removed so now there is no values on the chart. I then have a second sheet with data on it. The range is b4:c16. I want to point this data onto my chart on the other sheet.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved