legend

Hi, Can anyone tell me if there is a way I can remove data AND legend (ie unfilter) a set of data that is in a chart, where the values in one set are all zeros. In this table, I would NOT want to have Sales shown on the graph and legend when all values are zero. If any of the values in Sales...

I have a doughnut chart that is showing the results for the current quarter next to a column chart which shows the results for the current quarter and previous 2. When there is no data for the current quarter, the doughnut chart does not appear (which is fine) but the legend is still there. This...

I have a chart with eight columns, labeled by the legend below them. Excel defaults to listing these elements left to right, and then down, thus: 1 2 3 4 5 6 7 8 I think it's more user friendly for the legend to display columns: thus: 1 5 2 6 3 7 4 8 Is...

Is there a way to see when some legend items are not displayed? My dynamic chart has a legend with dynamic area size. So depending on amount of series and the legend are, some legend entries may not be shown (no space for them). I just want to add a warning to my user in such a case. I have...

Hi All, First off thanks for taking the time to read the following question/issue/plea for help I have a data set in pivot form which i have created a pivot chart and wondered if there was anyway that the Legend that is displayed could only show the items which have a greater or equal number...

Hello! I´m using vba code to create a chart and customize/emphasize a specific data point marker. But when I do that, the legend changes from showing a single label for my unique series of data to showing multiple labels, one for each legend entry corresponding to each data point (x-value) of...

I have a userform with labels (Label1.Caption = Store-1 & Label2.Caption = Store-2) I want to display on the Chart Legend. I would like to the Chart legend to display the captions of each label. How can I accomplish this? i.e. Legend 1 = Label1.Caption Legend 2 = Label2.Caption Also, my...

Ok I think this is simple. I created a bubble chart with info below. How do i get column A to be my legend? <tbody> <colgroup><col><col><col><col><col></colgroup><tbody> Risk Probablity - 1 (low) to 5 (high) Impact - 1 (low) to 5 (high) Traffic Light Risk management strategy Lack of...

I have multiple charts with the same series, so I want to write a code where I can just have 1 legend instead of having a legend per chart. I felt the easiest way was to write a code where I can have the legend cover the entire chart area. However, i've run into a problem where the legend...

Is it possible to change the legend order in a clustered bar chart? If so how? I cannot use 'Sort by columns' as it is greyed out. I have One column called WeekStatus which is supposed to go on the legend field. Entries for WeekStatus are: Current Week Previous Week The chart shows Current...

I have a shift schedule with symbol and legend with duration value of each shift symbol. I want to summarize the value corresponding to the symbols for each employee. Now I use: =COUNTIF($D5:$AH5;$A$13)*($N$13*24)+COUNTIF(D5:AH5;$A$14)*($N$14*24)+COUNTIF(D5:AH5;$A$15)*($N$15*24) where D5:AH5 is...

Hi, I have a file with a table that I have also created a graph to go with. When I created the chart, it looked great, but as I filter the data the legend changes. It will go from markers (which is what I want to show) to lines or just not have a marker or a line. Is there a way to set the...

I have been trying to get this to work in cell "Q4" all morning. I have put it every where in thisworkbook, Legend, and in a new module. Cant get it to work in cell "Q4" of the Legend. This is the formula I am useing. Private Sub Workbook_Open() Sheets("Sheet1").Range("Q4").Value =...

Hi All, I have a graph showing a set of data (from a pivot) which is only showing 6 items at the moment (which is correct) but the legend is showing all the other possible items that are included in the pivot but has a value of zero. Is there a way that the legend will only show items that are...

Good day, My legend order in chart is different from my chart series. How do get the legend order to be the same? I have excel 2016.

Dear Excel expert, Please advise how to move the legend inside the chart Picture is available in here https://ibb.co/kgmw8R

I have a row that includes a Legend for the worksheet. I'd like that to print on the bottom of every page...similar to the Print Title option. Is that possible? I cannot put it in the footer...too many characters, exceeding 250 characters. Also, would like the legend cells to be used in...

Having trouble with Pivot charts, adding the map and showing the legend at the bottom of the chart?

Hello all , I am a newb .. but I found in the free templates section of excel an employee attendance tracker , I think its great , but I wanted to modify it to my need just a little. If you download the template and look at the first sheet wich is the Calendar View.. there are colored squares in...

I have 15 series of data plotted against time on the x-axis. Some of the 15 columns contain numeric data and some contain #N/A. I have a macro that plots all 15. If 13 of the columns contain #N/A ofcourse no data is plotted and only 2 of the columns that contain numeric data are plotted. But...