legend

I have a interactive userform where users can select any number of 15 sets of data and then plot them (x axis is time and is common to all data sets). The data sets are picked by a "yes", "no" combobox before clicking the "Load" command button. How do I get the legend to plot only those...

Hey guys, I've searched the forum but I must not be describing what I would like to accomplish properly. There was 1 thread very similar, but it got derailed super fast. I would like change the cell format of the entire row (A3:F3) based on the drop down (column C) to match the formatting...

Hi I am sure a lot of people will have asked this before but I have googled and am not getting anywhere so apologies for repetition- if someone could point me to an answer I'd be very grateful. I want to make a column chart showing 3 variables- 'Book' along x axis (text); 'Score' along y axis...

Hi. I have created an Excel form that allows users to add up to 90-odd pieces of employee data including a picture of the employee and then send the information (as an attachment) to an email address via the commandbutton1.click event At the other end, the receiver of the email saves the...

I have a line chart where the data behind uses formulas to populate the values. Sometimes there aren't values for a particular month so I've use the N/A# error to stop these plotting. However, I'd like to be able to remove certain data series from the legend if EVERY value is N/A#. I've seen...

Hi There. When I create a scatter plot graph and then rotate the horizontal axis (which contains dates & times) so they are 90 deg, the date & time seem to be covering up the legend at the bottom of the graph and I don't know how to fix that...any help is appreciated! I have made scatter plot...

Pivot chart formatting changes (title position, size of legend box, positioning of values on pie chart) - won't save :( Workbook is password protected. 3 Pivot charts created off 1 data set. Excel 2013. Please help! :eeek: Thank you!

Hi I'm hoping someone can help me! I have used the Table Style feature from Excel 2007 to format my chart data source. I want to do this as this way the chart will automatically update whenever I add a new row - saving me having to use the OFFSET function to make my chart dynamic (this is...

I need a way to make a customized legend for a scatter plot, is there any way to do that through VBA? I have a scatter plot with some points highlighted green, and some points grey depending on the user selection and need to be able to create a legend based on what the user selects (e.g. Green -...

Hello all, just want to thank you in advance for any help provided here, its much appreciated. Here's my issue: Ive created several multi series charts, and when i enable the legend on the chart, it renders behind the axis ( this happens on both the X and Y axes). Can anyone help me out with...

i have a chart with data for each week. i then added the legend below to correspond with the data for each week. i'm having problems aligning the dates on the chart to the dates on the legend. when that happens, one of the dates goes away and it all ties together. i cant figure out how to do...

I have created a chart to show several different output options as a result of the input options. I am able to view 20 different outputs based on my input combinations. On the side of the table i simply have a column where the user can put an "x" and if so the results are plotted. I am able...

Excel 2007 does not have same chart options as previous version. My chart is good, my data is in the correct order, but my legend is not. How can I change just the legend order.

I’m facing an unexpected problem positioning the legend on a scatter plot chart (Excel 2007). Once the chart is plotted (through VBA), the left side of the chart legend overlaps with secondary Y-axi labels. So I’ve been trying to move the chart legend further to the right, against the chart...

Hi, Having a serious problem whereby Excel '07 is losing legends or parts of legends when printing or converting charts into pdf. From Google it would appear that it’s a fault in a recent windows update...

Is there a way using vba to delete unused legend entries from a chart legend? What I mean by this is that I have about possible 40 legend entries, which for some reason always are displayed, whether used or not. Often only about 3 to 5 of the legend items will have actual data that appears in...

I needed to add data labels containing the totals for a stacked column bar graph. I used both the line chart strategy and the x-y chart strategy. Both gave me totals. The problem now is that my legend reveals a third series which I do not want to show up. I do, however, want the other 2 series...

Hi there I need to plot some charts and to make sense of the charts I will rank them by different criteria. The charts will have the same teams on each so I want to keep the colours the same (Spurs are always white, Chelsea always blue etc). But in excel it assigns the legend colours in the rank...

Hi all! Here to scoop up some of your help again =) =P I have a bar chart and a lot of it is blank because a lot of the values i have are n/a (so zero wont show) is there a way to prevent the cart d\from displaying data if it is n/a or 0? maybe a macro of some sort? Cheers yall! ;)

Hi, Guys. I'm having some difficulties when copying charts from excel to a word document (the destination is really irrelevant). The second I hit Ctrl+c the chart "blows up" to almost twice its original size. In order for it to go back to its original size, I either have to hit Esc or perform a...