plotted

  1. A

    More than 255 series in a chart (sort of)

    Hey guys So i know that 255 is the maximum number of series that excel can plot. However would excel be able to plot more than 255 series on a graph but only having 7 or so displayed at one time? I am trying to make a dynamic chart that changes what series are plotted based on different...
  2. R

    Line chart to ignore blank cell values with formulas

    I have a line chart based on the months of the year and performance goals with a formula. I want the line graph to ignore the cells with the formula, until that month actually has data collected. That way if I have data plotted for January through July, August through December wont be plotted...
  3. R

    Change the color of the secondary axis title to the color of the data plotted

    Good day, I have two sets of data, one plotted on the primary vertical axis and the second plotted on the secondary vertical axis. The first data set is fixed, the second data set (on the secondary axis) is selected from a combobox list (13 possible choices). I'm looking to change the color...
  4. F

    XY Scatter help

    I am trying to create a scatter graph but cant seem to get excel to help me out! I want the axes to be like the chart on the left, but with the data labels to show the group names (eg a, b, c, etc). Trouble is, when I select the group names, the chart ends up looking like the chart on the...
  5. L

    plotted area gridlines

    Hi If I delete plotted area grid lines in excel chat, is there anyway to get them back (not to use undo)? Thank you.
  6. 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
Back
Top