Macro for Chart Scaling

  • Thread starter Thread starter herve
  • Start date Start date
H

herve

Hello All,
could someone know a macro that could scale a chart (in X).

Exemple,

from A1 to A365, I have dates 1/1/2005 to 1/1/2006.
The chart I have start from 1/1/2005 to 1/1/2006.

I would like - by clicking on a CommandButton - to change the 1st date
and the 2nd date (that I have put in cell B1 and B2)

Regards

Herve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

chart sheet value (Y) axis scale data report - an example 1
Protect worksheet cells but still allow macro to edit chartproperties 2
Tranfer data from Excel to word (Docx) via VBA in Excel 5
error message for phantom chart with log scale 1
Automatically selecting active chart 4
Add Data Scaling in same chart 3
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
Apparent Excel 2007 chart HasTitle race condition 5

Back
Top