Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
data series and axis labels
I will try my best to ask this question in a way that makes sense-
I have a line chart showing monthly sales. My X axis is labeled Jan - Dec and my data series is the sales by month. I have figures for Jan Feb Mar and Apr but since May - Dec are at $0 my chart currently shows a straight line down from Apr to May. Is it possible to stop the line at April yet keep the axis showing Jan - Dec? Thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
data series and axis labels
On Thu, 10 May 2007, in microsoft.public.excel.charting,
cdwinlib said: I have a line chart showing monthly sales. My X axis is labeled Jan - Dec and my data series is the sales by month. I have figures for Jan Feb Mar and Apr but since May - Dec are at $0 my chart currently shows a straight line down from Apr to May. Is it possible to stop the line at April yet keep the axis showing Jan - Dec? Yes, but I think you'll have to make the sales cells for May to December really actually blank to stop the line appearing. Fill the cells in as the year goes on with the real sales figures. If you are using the same data to present a table, and the table has to have actual zeroes, then have a separate table display from the graph data. There are other ways to achieve this (for instance, named ranges and the ever-useful OFFSET function) but they're a bit fiddly and not very time-efficient for busy people who just need to present a sales graph each month. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
data series and axis labels
Fill your May to December cells with =NA(), rather than blank or zero, then
they won't show up as zeroes on the chart. If you don't want the N/A# to show up on your sheet, you can hide them with conditional formatting (set font colour the same as the background colour). -- David Biddulph "cdwinlib" wrote in message ... I will try my best to ask this question in a way that makes sense- I have a line chart showing monthly sales. My X axis is labeled Jan - Dec and my data series is the sales by month. I have figures for Jan Feb Mar and Apr but since May - Dec are at $0 my chart currently shows a straight line down from Apr to May. Is it possible to stop the line at April yet keep the axis showing Jan - Dec? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Series Labels in Area Chart | Charts and Charting in Excel | |||
Combination chart: primary data labels obscure line series on secondary axis | Charts and Charting in Excel | |||
How to align the series with the-x axis labels? | Excel Discussion (Misc queries) | |||
Different X-axis labels for different Series in same chart | Charts and Charting in Excel | |||
How to add data labels from a series not displayed on a chart | Charts and Charting in Excel |