truncate chart

  • Thread starter Mike of Book Worm Angels
  • Start date
M

Mike of Book Worm Angels

How do I create a chart covering 7 years showing only the first 12 months and
the last 24 months without a flat line for the months in the middle?
 
J

Jon Peltier

You need at least one blank cell between the first 12 months and the last 24
months. A formula that returns "" does not count, as Excel considers "" to
be text.

- Jon
 

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

Filtered view of Visio Chart 0
Incone & Expenses Statement 0
Excel file won't save to iCloud on Mac 0
Excel 2007 charts: want to avoid zero values 1
Move Chart with Text 0
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
Occasional meter readings chart 0
Excel 2007 is charting skinny lines instead of columns 9

Top