graph from range

  1. R

    Change graph axis with VBA based on cell value that is a formula

    Hi, I am using VBA to automatically update the Y-axis minimum and maximum based on a value in my excel sheet. However, this value is determined by a formula (lowest value in the dataset - 10%). If I get rid of the formula in this cell and just have a value in there, it works fine using this...
    • rub
    • Thread
    • graph axis y graph from range vba
    • Replies: 9
    • Forum: Excel Questions
  2. S

    Graph last few rows in Sheet with incoming New Data

    Hey, I have new data coming in every week or so, it's always in the same format, and the new data always accumulates at the bottom. I need a chart or graph that plots the last few rows in the sheet (the new data). for example a graph the plots the last 10 rows, so that when the new data comes...
  3. S

    Array Formulas fail when inserting a new Row

    Hi I've used this forum as a knowledge base for a while now however this is my first post so I'll try to include enough information. I've created a spreadsheet that reports weekly information for my company on tab#1 whereupon the data input from the end of each week is entered on tab#2 and all...
  4. J

    Creating multiple column graphs from a range

    i found a macro i'm trying to modify to create 91 column graphs with the source data based on a range the below macro creates the graph but isnt selecting the source data correctly the data ranges from column b-j 2 rows for each month and its 2 months of data Data layout eg Series 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