x-y

  1. I

    Excel Trend chart with Dates on x-axis

    I have an variant array with date/value pairs. If I plot with a line chart, the dates are correctly represented on the X-axis. I would prefer to have it as an X-Y chart (so there are no lines connecting the points). If I change the chart type to X-Y an change the x-axis formatting to date x-axis...
  2. J

    Conditional Format by Date in X-Y Chart

    Hello Excel Gurus: I have a chart with X-Y data that is filterable by date using a pivot table. The date is not displayed on the table, but is used to select the data that does show up. My question is, is there a way to color the cells on the chart based on the date that is selected, say one...

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