excel graphs

  • Thread starter Thread starter adag59
  • Start date Start date
A

adag59

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?
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

League age chart 4
Bar graph and stacked bar graph on same graph 3
Creating date range for x-axis label in Excel '07 2
Date Difference in Complete Tax Years 1
Date Format + Graph 2
Scale of Graph Axis 2
Data Labels Disappearing 0
bar graph 5

Back
Top