Excel Secondary Axis 1

[f0rg3tfu1]

Hey guys,

So I have an excel pivot chart, dual axis, one showing average "uptime" percentage, and the other one shows totalcount of sites. I would like to be able to JUST show the number of sites without the bar (so basically just the label). Stuck right now... does anyone have ideas?

 

[SkipVought]

Hi,

Make the Fill property EMPTY, ie. no color along with the Line color.

And, of course, ADD the Data Value property for that series.

I might also change the Chart Type for that series as well to further distinguish it from the Percent Chart series.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[f0rg3tfu1]

Worked perfect thanks... do you know how I can line up all the counts in the center of each existing bar now?

 

[SkipVought]

Data Label has a CENTER Position property.

I'd recommend Excel Charts, by John Walkenbach if you want to go in-depth with Excel charts of all kinds. You can do weird and wonderful things with charts.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]