Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Chart sort data issue

so I have data is some columns that looks almost like this:

N95 N95 8GB E65
blah1 blah2 XXX

N95 6120 6300
some XXX some2

I hope you can imagine this in cells :) and ofcoruse more and more data,
in some cases as you can see there is 2 times N95 and under the models there
are results that could also mach (for instance 2 tiems XXX)
I need to create a chart that should take the data from these fields and
give me the result with the most recent unit that it can find in the cells,
for instance if there are 6 cells with N95 and 3 cells with XXX
it should give me a chart starting with N95 (rising to 6 in this case) then
N95 8GB (rising to #) etc.
and probably another chart that should work the same way but the result
should be the data (XXX or whatever is the most recent data in the cells)

I do not really need the chart to be combined with results based on type and
data since I can easily select them separatedly and simply make two separated
charts.

I hope someone can give me tips on how to do it cause I am really out of
guesses.

Thank you :)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort issue Patrick C. Simonds Excel Worksheet Functions 1 December 30th 07 11:37 AM
Data Series Name issue making a Chart from a PivotTable Marco Russo Charts and Charting in Excel 0 November 18th 07 10:16 AM
Sort/Filter issue terri Excel Worksheet Functions 4 May 16th 07 04:46 PM
Excel chart issue - cannot include a cell in my data series Russell-stanely Excel Discussion (Misc queries) 0 April 21st 06 05:29 PM
Header Rows and Sort Issue MikeL. Excel Discussion (Misc queries) 1 March 28th 06 12:23 AM


All times are GMT +1. The time now is 06:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"