line graphs

  1. R

    Plotting multiple data sets by year in Excel

    Hello, I have about have about 3 years worth of sales data and I'm comparing in-store to online sales. I summarized my data in a pivot table and included two slicers to easily click on a year and month to view the total sales for that period. I'd like to use a graph to show a visual of this...
  2. R

    Conditional Formatting Graph Markers?

    I am trying to recreate a line graph that contains UCL and LCL. However, the markers that are outside the limits are formatted differently. I know that I can do this manually. However, given that this graph will need to be refreshed monthly is there a way to conditionally format the markers...

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