Sign in to follow this  
Pallav

Normal Columns when 2nd Set Not Present

Recommended Posts

Hi,

I am making a chart that will be updated on a monthly basis and is a comparison to last year's information. I'm going to use pictures to help. This picture (for 1 year) is the ideal width of the columns:

f926c4d3-0094-4eca-827e-9a18.jpg

But when I add just one column of the following year, ALL the columns shrink in width:

600f0b08-6f18-4608-9228-be12.jpg

Is there anyway to have Jan look like it does in the second, but have the rest of the months look like they do in the first chart?

Thanks for your help,

Steve

Share this post


Link to post
Share on other sites

Thanks for the suggestion, but when I use this xml I get the same result as the second chart above. I am using MSColumn3D as you suggested.

<dataSet seriesName='XXXXXX' color='BBE0E3'>
<set value='XXXXXXXX.0000'/>
<set value='XXXXXXXX.0000'/>
<set value=XXXXXXXX.0000'/>
<set value=XXXXXXXX.0000'/>
<set value=XXXXXXXX.0000'/>
<set value=XXXXXXXX.0000'/>
<set value=XXXXXXXX.0000'/>
<set value=XXXXXXXX.0000'/>
<set value=XXXXXXXX.0000'/>
<set value=XXXXXXXX.0000'/>
<set value=XXXXXXXX.0000'/>
</dataSet>
<dataSet seriesName='XXXXXX' color='FF8040'>
<set value=XXXXXXXX.0000'/>
<set label='a' />
<set label='a' />
<set label='a' />
<set label='a' />
<set label='a' />
<set label='a' />
<set label='a' />
<set label='a' />
<set label='a' />
<set label='a' />
</dataSet>

I have also tried

<set /> and <set value='' />

and had no luck.

I appreciate Any Help.

Edited by Guest

Share this post


Link to post
Share on other sites

Steve,

 

 

 

I misunderstood your first post. If any of the column in MSColumn3D chart is missing, the other column does NOT acquire the empty space - and this is intentionally shown as missing data.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this