DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Excel 2010 Barchart Problems

 
Post new topic   Reply to topic    DPlot Forum Index -> Excel
View previous topic :: View next topic  
Author Message
DWW



Joined: 19 Sep 2014
Posts: 1

PostPosted: Sat Sep 20, 2014 6:53 am    Post subject: Excel 2010 Barchart Problems Reply with quote

I'm seeing a number of problems when I try to create a bar graph of the following Excel 2010 data:

Region Cow Sheep Goat W Buf Blend

Abruzzo 6 2 4 1 8
Lazio 7 8 3 5 7
Marche 8 6 5 6 9
Molise 5 6 5 4 8
Tuscana 15 15 15 15 15
Umbria 7 8 5 3 6

When the chart first appears, the X headings are offset to the right causing me to have to manually change the label values to shift them back left where they belong.

In trying to change the colors of bars, right clicking a bar sometimes brings a pop up with "color" in it, sometimes not. If I do get the popup with "color" and change color, the color of a different bar (other than the one clicked) changes.

Can anyone help with these? Thanks very much.
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Sun Sep 21, 2014 3:41 pm    Post subject: Reply with quote

Quote:
When the chart first appears, the X headings are offset to the right causing me to have to manually change the label values to shift them back left where they belong.


Which Add-in command are you using? When I use "Bar chart (label, Y1, Y2,...)" the placement of the labels along X looks perfect to me.

Quote:
In trying to change the colors of bars, right clicking a bar sometimes brings a pop up with "color" in it, sometimes not. If I do get the popup with "color" and change color, the color of a different bar (other than the one clicked) changes.


Thanks for pointing out the problem. At first I thought it was just a tolerance problem, but it is worse than that. Until this is fixed, use the Colors button on the toolbar.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
jsc



Joined: 02 Dec 2005
Posts: 222

PostPosted: Sun Sep 21, 2014 8:47 pm    Post subject: Reply with quote

Using Bar Chart (Label, Y1, Y2,...) from Excel 2007 I get what DWW describes, ie, the X-axis labels are set one set to the right. The label "Umbria" does not show on the plotted data - it's off screen to the right.

However, it seems that the cause is the extra empty line between the first and third rows. Get rid of the empty line, and the data plots correctly.

WinXPsp3, xl2007, DPlot 2.3.5.3
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Sun Sep 21, 2014 10:07 pm    Post subject: Reply with quote

Ah, good catch! When I tried it I just reflexively deleted that blank line.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> Excel All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group