Excel macro – create a chart

360 pts.
Tags:
Excel 2007
Excel Charts
Macros
Microsoft Excel macros
I created a macro that reforms my data and creates a chart. Teh macro also includes selecting a chart layout that has an x and y axis field that I want to enter in some text. My macro works all the way except it does not record the content I put into the X and Y axis.

 

Why is that? and how can i get around the problem? I want the macro to create a standard looking chart with proper x and y axis titles.



Software/Hardware used:
Excel 2007

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Chippy088
    Can you post the macro? It will be needed if we are to help you find what is going wrong. I have tried macros that have been posted as having an error, and it has done what was wanted on my machine. It could be a machine setting, or an error in the coding.
    4,625 pointsBadges:
    report
  • jkeri
    I can't post the macro since it has been deleted.. sorry
    360 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following