LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 98
Default If there is no data i dont want the line to go down to 0%.

Hi,

If i have some data in percentage month by month. In some of the
months i dont have any data.

In this condition if I draw a line graph the line goes down to 0% and
again it comes up which create a wrong picture in the mind.

Is there any way by which if there is no data for that particular
month it should directly get connected to the next month.

Regards

Heera
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
source data editor in Excel 2007 dont seem to allow copy and past. Pieter Charts and Charting in Excel 1 May 8th 08 12:35 AM
graph, data lables value, dont show zero values Madeleine Charts and Charting in Excel 1 February 14th 08 05:55 PM
I have data in a time series that starts from 0 but i dont want x. Zoe Charts and Charting in Excel 3 January 10th 08 12:35 PM
Want to choose last filled line, but dont know how? Rikku Excel Worksheet Functions 3 September 27th 06 03:08 PM
x-axis dates dont match up with the nodes on the line graph changetires Charts and Charting in Excel 1 August 11th 06 01:45 PM


All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"