1. A

    Dynamic Legend on Excel Graph

    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...
  2. B

    Remove legend where no data in the chart

    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...
  3. B

    Chart legend in columns, not rows

    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...
  4. K

    Check if all legend items are displayed

    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...
  5. P

    Excel Pivot Chat - Legend Help

    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...
  6. C

    Avoid unexpected legend change when editing single point marker in chart

    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...
  7. A

    Userform Label on Chart Label

    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...
  8. D

    Bubble Chart legend

    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...
  9. A

    VBA have legend on the top left corner of chart area

    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...
  10. T

    Change Legend Order in a Clustered Bar Chart

    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...
  11. R

    How to sum up the values of the working schedule symbols from a range that matching the value legend for these characters

    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...
  12. S

    Scatter Chart, Legend issues

    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...
  13. G

    Help with vba code placement please

    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 =...
  14. P

    Legend issue on graphs

    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...
  15. S

    Legend Order

    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.
  16. T

    Pie Chart

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

    Print Row at Bottom of Every Sheet

    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...
  18. L

    Pivot Charts

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

    Attendance tracker Template

    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...
  20. R

    Removing dummy series from my legend

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back