Move a Column Off the Y Axis

P

Phil Hageman

I have a combination chart where a single column plotted over two area series
(each has two equal-value data points). The plot area is colored green,
series1 is yellow, and series2 is red. The idea is to have the column move
up and down the chart, in and out of the three colored bands. This works
except the column is next to the Y axis. Is there a way to move the column
to the right where the color bands would show on both sides of the column?
 
T

Tushar Mehta

Option 1: Add a secondary x-axis (that is where the column chart should
land up). Now, format the axis so that 'Value (Y) axis crosses between
categories' is selected.

option 2: Create the column from a three cell range, with the 1st and
the 3d being empty cells.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use text descriptors as Y axis units 1
How to chart data like this? 0
X-Axis Appearing in Plot Area 2
Chart distorts secondary axis when the x-axis is logarithmic 5
Help with Bar-Line Chart..not aligned?? 1
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
changing area color based on line value 2
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1

Top