Results for "chart macro function"
10 results for this search
Hello and welcome,
try this, select the data and execute this macro.
Sub createcolumnchartwithselection()
Set ch = ActiveSheet.Shapes.AddChart2(366, xlColumnClustered)
ActiveSheet.ChartObjects(ch.Name).Activate
ActiveChart.ChartArea.Select
ActiveChart.ChartStyle = 201
End SubHi there, i am new to vb excel and i need help.
What would be the macro for making excel create time series chart if two columns are selected where the left column is dates and right column is data
Hello,
Can you provide an example of your data ? We don't need the real datas, but to understand how they are structurated, and what do you want exactly at the end (chart type and content, etc). An example file would be appreciated.
Every month, I download price data from the system and calculate the average price for that month. I then create a chart to visualize the inflation trend for that month. Can you provide a excel VBA code to automate this process?
- Import data - calculate average - build chart
Next month , import data add it to the same last month.. calculate the average . Build chart
I guess u can specify which folder to load files from at startup via the:
Advanced>General section of the Options dialog.
Also, any files stored here...
C:\Documents and Settings\user\Application Data\Microsoft\Excel\XLSTART
...will also be opened at startup.
My mistake
Now I saved as an XLAM file.
Does the file need to be opened to use the function in other files?
Hi,
The only way to do this is to save your file as XLAM, or please tell why you can't achieve this.
Hello everyone!
I wrote a custom function and I want it to work on any Excel file that I open.
How can this be done?
From an inquiry so far I understood that you can save as an XLMA file only that I could not
Thanks to the respondents
Hello,
thank you very much for your attention
Regards,
Ferdinan
Hello,
Realy they are the same.
Use the one that seems the easiest to program.
I'm going to try both methods and see which is the most efficient?
Thank you very much for your help.
Regards,
Ferdinan
Hello,
I have a file in which I have many functions and the file goes a little slow.
Which of these methods is the most efficient, so that it goes faster?
Regards,
Ferdinan
Hello,
The best for you is to create a Name with this Formula
Select the Cells "E2" and copy the Formula (Select it in the Formula Bar)
In the ribbon Open the Name Manager
Add a new name (By exemple SUBSTFRM) and in the ReferTo area put the Formula
Send Ok
Now you can use "= SUBSTFRM" instead of the original function.
Then in VBA you can write :
Range("E2:E10000").Formula = "=SUBSTFRM"
That's enough !
See the exemple...
Good afternoon,
Please, can you help me with this problem?
In the attachment, in column E I use a search function (= INDEX (Sheet2! $ E $ 2: $ E $ 32; MAX (INDEX ((Sheet2! $ A $ 2: $ A $ 32 = C2) * (Sheet2! $ D $ 2: $ D $ 32 = D2) * ROW (Sheet2! $ D $ 2: $ D $ 32) -FILA (Sheet2! $ D $ 1);))).
I would like to load this function in that column E with a macro.
How should the programming of the macro be?
Greetings,
Ferdinan
Hi ! Lisa Nguyen,
Here, your Excel File is back, with automatic conversion.
If you agree, you can display the corresponding color with your VBA Module3. Sub RGB_TO_HEX_COLOR()
See my Note in Sheet1.
Hello,
Understand you cannot attach your workbook ... for confidential reasons ...
However, the one thing you could do is insert the code you have created ...
It might be that ... just by looking at your macro ... a solution might pop up ....
Good evening Lisa,
I propose you here a fully automated version of the macro, meaning that :
When you modify the hexa color, it will both change the RGB values accordingly and change the color of the colored cell automatically too.
When you modify one of the RGB value, it will both change the Hexadecimal value accordingly and change the color of the colored cell automatically too.
No need for any button to apply the tranformations.