chart data range

  1. N

    Chart data

    I have data for a chart where it works on 'weeks out' going from week 20 (this week) to week 1 (target week). I have set the data up in this way but the chart shows it back to front - in other words it goes from week 1 to week 20 instead of the other way around. I have attached 2 screenshots to...
  2. E

    Dynamic range name based on value in another row

    Hello, I am working on a template for charting data. I want to be able to use a dynamic named ranges for series data so the chart is dynamic and I don't need to manually update the series data everytime. Sample number is x axis and Average Weights is the y axis. I made the dynamic range names...
  3. R

    Fixing a chart data range

    Hi All, I have what is probably a simple problem but can't see a quick fix. I have a number of charts that feed of data in other tabs. The top row of the data tabs represent dates. Periodically I need to update these sheets and have some VBA code that does this. When the update runs, part...
  4. C

    Way to input chart data range through value in cell

    Hello, I'll get straight to my problem. I have a sheet filled with graphs and one dropdown menu (7 menu options). Another sheet is filled with values per category (one graph per category in the other sheet) and also contains one dropdown menu (with the same link as the one in the other sheet)...
  5. C

    Chart data range based on value (range) in cell

    Hello, I have some formulas generating a data range for a chart (Charts("Age")). However, I don't seem to get this dynamic data range into the chart's data range. I've read that it's impossible through 'regular Excel', but I haven't succeeded with VBA so far either. I've tried using a named...
  6. S

    How to get the Chart Data Range without navigating through series collection using Excel VBA

    How to get the Chart Data Range without navigating through series collection using Excel VBA. The Chart Data Range is the value that can be seen when we click SELECT DATA on the chart.

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