Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
SM
 
Posts: n/a
Default Incorrect Data Labels on Column Chart

Hi,

I'm having problems with certain data labels on columns within a chart,
where the column reflects the correct data, but the data label contains the
incorrect value. The value is the previous value of the chart before the
data series were changed.

Here's some background info that may or may not help explain why this is
happening. I started with a worksheet containing 10 charts (5 line and 5
column), which worked great. This worksheet served as a template for 9 more
worksheets, each containing the same 10 charts, linked to different data
series. There weren't any issues copying these initally, but towards the
last 8, 9 or 10 worksheets, the values on the final data point of each column
chart would not update.

I've tried closing the file in the hope it would refresh the data, but that
didn't help. I'm not sure where to look next! Any suggestions or help would
be appreciated!

Thanks,

Sean
Reply
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
chart labels from a column of data LRM Excel Discussion (Misc queries) 1 March 7th 06 05:14 PM
3D column chart, stacked waeltlmi Charts and Charting in Excel 4 January 10th 06 07:44 PM
Chart problem: values in column A don't show as labels on x-axis digicat Excel Discussion (Misc queries) 1 January 9th 06 07:08 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
How do I add column A data labels to a scatter of columns B and C? Christina1 Charts and Charting in Excel 3 March 27th 05 03:43 AM


All times are GMT +1. The time now is 08:49 PM.

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"