X Axis Values based on Cell Values - Chart

Smergen

New Member
Joined
Jun 20, 2005
Messages
32
Hi Gang,

Just a quick query to see if there is a simple way to have the X axis of an X-Y plot dependant on cell values in a worksheet?

In reference to my problem, I have a rather lengthy long section and wish 'zoom' in on certain sections of the graph. Obviously I can do this by changing the values within the chart properties but was wondering if there is a quicker way.

Any thoughts on the matter would be appreciated.

Cheers,
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Smergen

New Member
Joined
Jun 20, 2005
Messages
32
Thanks Jon, I do mean the X-axis. I think your link has the right answer as well. I'll let you know how I get on.

Cheers,
 

Smergen

New Member
Joined
Jun 20, 2005
Messages
32
Jon,

Thanks for those solutions, they seem to do the trick. I'll probably tailor the macro solution, but very handy indeed.

Cheers,

Smerg
 

Watch MrExcel Video

Forum statistics

Threads
1,114,051
Messages
5,545,726
Members
410,702
Latest member
clizama18
Top