Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart type affecting data order
When I change the chart type from bar to line (for example), it changes the
order that the data is displayed in the data table. How do I keep data in the data table in the same order that I entered it? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart type affecting data order
You would have to use an alternative to a data table. Make a table in the
worksheet, where you have much finer control over what appears, where it appears, and how it appears (formats). Then either situate the chart close to this table, or use the camera tool to paste a dynamic picture of the table one or near the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tommy" wrote in message ... When I change the chart type from bar to line (for example), it changes the order that the data is displayed in the data table. How do I keep data in the data table in the same order that I entered it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert New Data in Order on an Existing Chart | Excel Discussion (Misc queries) | |||
When I add data to my chart it changes my chart type-Help!!! | Charts and Charting in Excel | |||
How do I rank chart data so it appears in a specific order? | Charts and Charting in Excel | |||
data order in a chart | Charts and Charting in Excel | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel |