Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am making a simple bar graph, but everytime I try to change the x axis from
numbers to years 1996, 1997, 1998, etc, the bars disappear; what am I doing wrong? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It sounds like you are changing the axis, but it is still graphing the
original numbers, and they are very small compared to 1996, etc, so the bars are all not on that scale. "adag59" wrote: I am making a simple bar graph, but everytime I try to change the x axis from numbers to years 1996, 1997, 1998, etc, the bars disappear; what am I doing wrong? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Try this, with the series (for the bars) selected on the chart, choose Chart, Source Data, Series tab, place your cursor in the Category (X) axis labels box and highlight the range containing the year. If there is more than one series in the Series window, select and remove any you don't want. -- Thanks, Shane Devenshire "adag59" wrote: I am making a simple bar graph, but everytime I try to change the x axis from numbers to years 1996, 1997, 1998, etc, the bars disappear; what am I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
graphs in excel | Charts and Charting in Excel | |||
Excel graphs | Excel Discussion (Misc queries) | |||
Excel Graphs | New Users to Excel | |||
Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
Automatic Graphs/ Dynamic Graphs | Charts and Charting in Excel |