Thread: Formatting Axis
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
readystate readystate is offline
external usenet poster
 
Posts: 25
Default Formatting Axis

I am building a Line Chart on Excel 2003 with data from multiple sales
divisions trying to show their growth in month to month sales. At the same
time, I want to include a line for the total company but when I do, the lines
for the divisions are all clumped together. How do I show, for instance, a
set of four numbers running with dollars ranging from $500,000 to $3,000,000
for each month and then show the main company summed at $10,000,000 per month
without having the first 4 lines all bunched together? Is there a way to
omit the values from $4,000,000 to $9,000,000?

Hope I explained it right. I appreciate any assistance.