Simple Axis Title Question

[Hockeystar]

How do I get excel to automatically add the axis titles of my data onto the graph. Right now I manually have to add the axis titles and manually remove the incorrect title that excel puts on. This is extremly fustrating and the time consumed adds up when your doing 20 tables for a report. I tried to make a template but that didn`t solve my problem.

[6StringJazzer]

Welcome to the Forum!

What is incorrect about the titles used by Excel?

This kind of things can be done with macros but can you provide more detail? Ideally it would help if you attached a sample workbook showing what kind of results you're looking for.

[Hockeystar]

Attached is the problem I`m having. This should clarify things.

[Andy Pope]

Chart to not have automatic assignment of axis titles.

By default if the chart contains 1 series the chart title is applied using the series name.
So you could get automatic chart title by changing B1 to "My Sample Graph".

X and Y axes titles will need to be applied manually.

[Hockeystar]

Thanks for replying. It makes no sense why excel won't add title axis automatically. When does someone every create a graph with no axis titles?

[Andy Pope]

The main reason is where would be a convenient and consistent place to put the axis text in order to excel to automatically detect it.
You can not use the preceeding row or column as these can be used for multi level category or series names.

I would say half the charts I encounter have no axis titles.

[6StringJazzer]

Notwithstanding Andy's observations, which I agree with, I think we can solve your specific problem with a macro.

Rename axes.xlsm

For each chart, it will prompt you whether you want to change the chart title. (Based on your example there is no automatic way to determine the chart title.) Then it will label the axes according to what you have described.

This macro assumes that:

1. All data is formatted in columns
2. There is one series per chart
3. The desired x axis title is the series title
4. The desired y axis title is found in the cell immediately above the first y value cell

To run the macro push the button. This example shows multiple charts that all use the same data, just as a demo. I have not tested for multiple charts that each have their own data, which is how I assume you need to use it.