| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Time Series Chart Data Plot Line ''Disappears'' When Y Axis Formating Is Changed
I apparently don't know how to "Select the series"? Please explain. Click on the plotted series in the chart. I, of course, tried to select the cells for the relevant X and Y values. However, this did not give anything like the formula you described. In the Chart menu Source Data Series dialog? I continue to be astounded that something that should be so simple is seemingly so complicated and hugely time-wasting. Often it's made more complicated by a user having data formatted nicely for a tabular report but not arranged efficiently for a chart. See my follow up to Jerry's post to see an efficient data layout for a chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combination chart: primary data labels obscure line series on secondary axis | Charts and Charting in Excel | |||
| TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
| chart formating disappears when i refresh pivot table data | Excel Discussion (Misc queries) | |||
| second axis disappears on pivot chart when page field changed | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
Threaded Mode
