Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort issue | Excel Worksheet Functions | |||
Data Series Name issue making a Chart from a PivotTable | Charts and Charting in Excel | |||
Sort/Filter issue | Excel Worksheet Functions | |||
Excel chart issue - cannot include a cell in my data series | Excel Discussion (Misc queries) | |||
Header Rows and Sort Issue | Excel Discussion (Misc queries) |