Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / November 2003

Tip: Looking for answers? Try searching our database.

Chart from nonadjacent selections

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ar76 - 26 Nov 2003 15:03 GMT
I am trying to create a chart using nonadjacent selections and the chart
wizard does not seem to be representing the data in a way I can
understand.  It has worked fine for two previous charts - producing a
column chart showing a comparison between two sets of figures across a
number of weeks.  This time the chart wizard seems to be spreading the
data out using X categories I cannot understand and not showing the
data grouped by week for comparison.

Any ideas what I can do?

------------------------------------------------
Jon Peltier - 26 Nov 2003 17:33 GMT
Not knowing the structure of your data (you could paste some as text
into your next post), I'd suggest selecting a blank cell before running
the chart wizard.  On step 2, click on the Series tab, click Add, then
select the ranges for series name, values, and category labels.  Repeat
with Add for any additional series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> I am trying to create a chart using nonadjacent selections and the chart
> wizard does not seem to be representing the data in a way I can
[quoted text clipped - 7 lines]
>
> ------------------------------------------------
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.