Diogo Silva
New Member
- Joined
- Jun 8, 2020
- Messages
- 3
- Office Version
- 2013
- Platform
- Windows
Hello everyone,
I came here because i have this problem that is driving me nuts. I can't find nothing similar on the internet (maybe because it's kind of hard to explain without images).
Here's the problem:
- I want to use a macro to copy a box plot graph from a sheet and paste it on another sheet using the following code (since i am running a for cycle i use some variables on the coordinates in the sheet):
Sheets(s + 4).Select
ActiveSheet.ChartObjects("Gráfico 9").Activate
Application.CutCopyMode = False
ActiveChart.ChartArea.Copy
Sheets("Print").Select
ActiveSheet.Cells(l + 22, 3).Select
ActiveSheet.Paste
- Using this code i obtain something like this:
As you can see, the "Cmin" value is in a very strange format (,320.0) as the value in the table is just 0,32.
- Once i Copy and Paste it manually, even after using the macro, i obtain the 0,32 on the graph.
- This also works if i just right-click then "select data" and just cancel without any modification.
- If I change the decimal cases shown on the table it comes back to normal too, but it would be too much work to change this format on every table.
Do you have any suggetions for solving this problem?
Thank you in advance for the attention.
I came here because i have this problem that is driving me nuts. I can't find nothing similar on the internet (maybe because it's kind of hard to explain without images).
Here's the problem:
- I want to use a macro to copy a box plot graph from a sheet and paste it on another sheet using the following code (since i am running a for cycle i use some variables on the coordinates in the sheet):
Sheets(s + 4).Select
ActiveSheet.ChartObjects("Gráfico 9").Activate
Application.CutCopyMode = False
ActiveChart.ChartArea.Copy
Sheets("Print").Select
ActiveSheet.Cells(l + 22, 3).Select
ActiveSheet.Paste
- Using this code i obtain something like this:
As you can see, the "Cmin" value is in a very strange format (,320.0) as the value in the table is just 0,32.
- Once i Copy and Paste it manually, even after using the macro, i obtain the 0,32 on the graph.
- This also works if i just right-click then "select data" and just cancel without any modification.
- If I change the decimal cases shown on the table it comes back to normal too, but it would be too much work to change this format on every table.
Do you have any suggetions for solving this problem?
Thank you in advance for the attention.