?
Solved

Having the value (Y) axis of all but one of a chart's series cross between categories

Posted on 2011-05-03
5
Medium Priority
?
274 Views
Last Modified: 2012-05-11
Please take a look at the attached workbook. Is there a way to have the value (Y) axis of one of the series NOT cross between categories, while the others continue to do so?

Thanks
CustomCharting.xls
0
Comment
Question by:gabrielPennyback
  • 3
  • 2
5 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 35532759
Hello,

- select the series column for Week 13 and open the format dialog
- on the Axis tab click Secondary Axis and OK
- with the chart selected, click Chart menu > Chart Options > tick the box next to Category (X) Axis in the "Secondary Axis" panel and OK
- the series will now be at the top of the chart, but we'll fix that later.
- double click the secondary X axis at the top of the chart
- on the Scale tab, untick "Value (Y) axis crosses between categories" and OK
- double click the secondary Y axis
- On the Scale tab, set the maximum to 1.6 (the same max value as the primary axis)
- change the value for "Category (X) axis crosses at" to 0 and OK
- select the secondary Y axis and hit delete.

See attached.

cheers, teylyn


Copy-of-CustomCharting.xls
0
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 35534864
Forgot one step

between these two steps

- on the Scale tab, untick "Value (Y) axis crosses between categories" and OK
- double click the secondary Y axis

change to

- on the Scale tab, untick "Value (Y) axis crosses between categories"
- on the Patterns tab, set major, minor tick mark type, tick mark label and Lines to "none" and OK
- double click the secondary Y axis
0
 
LVL 50
ID: 35535433
cleaned up version attached
Copy-of-CustomCharting.xls
0
 
LVL 1

Author Comment

by:gabrielPennyback
ID: 35553307
That is extremely cool. Thank you for being so thorough and specific!

- John
0
 
LVL 1

Author Closing Comment

by:gabrielPennyback
ID: 35555593
Thanks again, teylyn.  :-)

- John
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question