Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Another Exciting Data Table Question!!!!
Hi all! I'm having trouble with my data table. It has to do with the catagory (x) axis labels and the order in which the data table lists these. The default, and only perceivable way I've been able to format my information ends up looking like this: (Bar Chart) 5 4 3 2 1 (Data Table) 1 2 3 4 5 Why does it insist on reversing the order for the data table? I am assuming that most people would want the data labels to read up to down on the x axis, then left to right on the data table in the same order. The way this is working is that, no matter how I move around the data or relabel the info, it winds up being backwards. If this is how the data table functions now and I should just create a text table below my chart, please tell me so, cause this is driving me nuts. Thanks! -- xinekite ------------------------------------------------------------------------ xinekite's Profile: http://www.excelforum.com/member.php...o&userid=23781 View this thread: http://www.excelforum.com/showthread...hreadid=374162 |
#2
|
|||
|
|||
That's the way data tables work. There's an alternative on Tushar
Mehta's site: http://tushar-mehta.com under 'Custom Chart Table' xinekite wrote: Hi all! I'm having trouble with my data table. It has to do with the catagory (x) axis labels and the order in which the data table lists these. The default, and only perceivable way I've been able to format my information ends up looking like this: (Bar Chart) 5 4 3 2 1 (Data Table) 1 2 3 4 5 Why does it insist on reversing the order for the data table? I am assuming that most people would want the data labels to read up to down on the x axis, then left to right on the data table in the same order. The way this is working is that, no matter how I move around the data or relabel the info, it winds up being backwards. If this is how the data table functions now and I should just create a text table below my chart, please tell me so, cause this is driving me nuts. Thanks! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem making versions of a table by changing sourse data in another workbook | Excel Discussion (Misc queries) | |||
1-variable Data Table dependent on MS Query fails to update correctly | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Table Question | Charts and Charting in Excel | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions |