Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
SITUATION: I've never used Exel for chart-creation. This question
probably makes that all too obvious. Using Exel 2002's chart wizard, I was able to generate a time-series chart which displayed my data. However, on the resulting chart, the Y Axis displayed the years generically (1-30). I wanted this axis to display the years specific to the dates involved (e.g. 1920-1947). I right-clicked on the Y Axis and choose <Format Axis, followed by the Scale Tab. There I set "Minimum:" to the starting data of my time series, "Maximum:" to the ending date. All other values were kept the same. I then clicked OK. The chart was now formated just the way I wanted it. However... PROBLEM: The data plot line on the newly-formated chart is invisible -- it "disappeared". QUESTION: How do I get the chart to display **both** the time-series data on the Y-Axis by date and the resulting data plot? COMPLAINT: This **really** shouldn't be this difficult!!!!!!!!!!!!!!!!!!!!! Thanks, 2privatus |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |